In the attachment you see Columns B are the number(s) associated to Column C.
You'll notice (example: 7 is always associated with 23.3%, etc.)
In column D I did a sort of eliminating all doubles and placing those percentages in Column E.
The formula I'm using =IF($C$1:$C$66,B1,E1) isn't giving me an actuate number/percentage association...
Obviously my formula is missing something...what could it be?
Last edited by khank; 09-25-2012 at 09:46 AM.
Maybe
=INDEX($B$1:$B$50,MATCH(E1,$C$1:$C$50,0))
In F1 and copy down.
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.
Works perfectly...thanks for all your help!
You are welcome!
Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks