Hi, there
I tried to use SMALL Function to look up the Lowest Value and F Name (before Amount) without Zero & Percentage value. Meanwhile, I would like to know the 2nd & 3rd Smallest Value and F Name as well. Unfortunately, it did not not work as the Lowest value showed Percentage value (instead of Amount).
Fyi, there is same value with the different F Name for those styles. Hence, I would like to know the 2nd & 3rd occurrence of the F Name for each style.
Enclosed the attachment for your reviewing. Would you please help to advise the formula?
Style F Name 1 ID F Name 1 F Name 1 Amount F Name 1 Amount % F Name 2 ID F Name 2 F Name 2 Amount F Name 2 Amount % F Name 3 ID F Name 3 F Name 3 Amount F Name 3 Amount % F Name 4 ID F Name 4 F Name 4 Amount F Name 4 Amount % Lowest Value without Zero & Percentage Header Name with Lowest Value without Zero & Percentage 2nd smallest number without Zero & Percentage Header Name with 2nd smallest number without Zero & Percentage D123 12345 ABC $ - 0.00% 13456 DEF $ 3.25 0.30% 14567 GHI $ 3.25 0.30% 15678 JKL $ 3.25 0.30% $ 3.25 DEF $ 3.25 GHI D124 12345 ABC $ 2.05 0.00% 13456 DEF $ 1.00 0.30% 14567 GHI $ 0.95 0.80% 15678 JKL $ 1.50 0.25% $ 0.95 GHI $ 1.00 DEF D125 12345 ABC $ 1.05 1.00% 13456 DEF $ 1.30 0.20% 14567 GHI $ 0.70 0.35% 15678 JKL $ 4.00 1.50% $ 0.70 GHI $ 1.05 ABC D126 12345 ABC Nil 0.00% 13456 DEF Nil 0.00% 14567 GHI Nil 0.00% 15678 JKL Nil 0.30% $ - ABC $ - DEF D127 12345 ABC $ - 0.00% 13456 DEF $ - 0.00% 14567 GHI $ - 0.30% 15678 JKL $ 2.25 0.30% $ 2.25 JKL $ - ABC D128 12345 ABC $ 2.30 0.90% 13456 DEF $ 1.30 0.20% 14567 GHI $ 2.30 4.00% 15678 JKL $ 4.00 5.00% $ 1.30 DEF $ 1.30 ABC