Hi there. I hope u can help me. I have a question about list of excel. it has a name list and that has many salaries. I have to create a formule that will show the lowest salary which show the name of it.
it will find the lowest salary and it will show the salary which has it. Thanx for ur helping
Last edited by arlu1201; 05-30-2012 at 07:51 AM.
Why dont you attach a sample file?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
i couldnt find how to attach the file here. Can u help me to attact the file or if u understand me plz explain how to create a formule that i need
Hi
With your nanes in Column A & Salaries in column B, try this.
=INDEX(A1:A100,MATCH(MIN(B1:B100),B1:B100,0))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
i attached. Can u check it
Try the formula in post 4. I tried it and it works great.
i tried but it doesnt workpls try this on my file and check it.
Thanks Arlette!
By the way, which column is Salary Column?
salaries are in Column K but i heard something about this kind of formule. It is if we have same salaries between 2 persons that wont work it. So i tried this in Column A as different numbers
This is the formula you need
=INDEX($B$2:$B$36,MATCH(MIN(K2:K36),K2:K36,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks