LinkBack URL
About LinkBacks
Hi,
Can some one help me out in identifying the Slabs and find out the percentage ... i am finding it difficult in doing in Percentage column in attached file
Hi,
Can some one help me out in identifying the Slabs and find out the percentage ... i am finding it difficult in doing in Percentage column in attached file
Try this..
Formula:
Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi Debraj,
You are Superb.. Thank you soo much. I have add reputation
Or try this...
=LOOKUP(2,1/($J$4:$J$41=B3)/($K$4:$K$41<=C3),$M$4:$M$41)
just press enter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks