I need help with comparing values in Excel and retrieving!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zabedi@gmail.com - 16 Nov 2006 22:07 GMT

Hi,

I have absolutely no idea where to start!!!! I know it's simple but
I've never done this before...I needed to figure out how to compare
values in a row and retrieve a value if the condition is true. However
if more than one values meets that condition, I need it to remain
blank...

Like for the following example, since only the Accounting Linksys field
is occupied, the Business Unit field should return the value
"Accounting"...

Vendor Accounting Finance IT Business Unit
Linksys $30,000,000 Accounting

But if the row contains more than one value, the Business Unit field
should remain blank...
Vendor Accounting Finance IT Business Unit
Unix $40,000 $5,000 $300 --
Lycos

Can anyone help me??

Thank you so much!

Zak

Reply to this Message

Dave Peterson - 16 Nov 2006 23:54 GMT

Assuming that the headers are in A1:E1:

Put this in E2:

=IF(COUNTA(B2:D2)<>1,"",INDEX($B$1:$D$1,MATCH(TRUE,B2:D2<>"",0)))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

> Hi,
>
[quoted text clipped - 22 lines]
>
> Zak

Signature

Dave Peterson

Reply to this Message

Rate this thread: