LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default HELP! I'm not sure what formula to use!

A B c D (Result)
123 35.5% 888 41.3%
888 41.3% 020 0
456 52.12% 030 0

If the number on column "C" its also somewere on column "A" I need the value
on the righ of that number on column D.

ie:
if 888 is in column A I need the value of 888 wich is 41.3%
on column "D" Result.

Column "A" has thousands of rows that;s why I need a formula.
I was thinking on this one.
IF(COUNTIF(A2:A4,C2)0,B2) but doesn't give me the appropiate value it gave
me in this case 35.5% of course.
Please help,
Thank you

Hernan




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"