• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ctrl+f not yielding result

N

niting

New Member
I applied subtotal for some items in a large range of cells!! When I used the large formula for picking up "n" largest items, I got the correct answer. However, when I tried to use index match for retrieving the corrosponding value, the formula din't work! I tried to manually search for the value! The strange part was that the excel returned the value which was originally appearing in the data! The values which was arrived at by subtotal formula was not returned when I used ctrl+f.

Any inputs as to why the value was not returned!!


Thanks

Nitin
 
Nitin


It is quite possible that there are hidden decimal parts of the number you aren't seeing due to display format and rounding


Increase the decimal places and try again
 
Hi,


Try using MAX Function.


=MAX( argument1, argument2, ... argument30 )

=MAX((sheet2!$F$1:$F$1000)*(sheet2!$A$1:$A$1000=sheet2!A1))


Thanks,

Suresh Kumar S
 
You must log in or register to reply here.
Back
Top