General discussion

Locked

Making a comparison report in Excel

By lathe ·
I need to make a comparison list in excel

the data should be like this:

a,b,c and e is the suppliers and the numbers are their quotes (Amount)

a b c e
2 3 1 4
3 1 4 2
4 2 3 1

I wand to pick the nameof the supplier quoted low.
The result should be

a b c e Result
2 3 1 4 c
3 1 4 2 b
4 2 3 1 e

Thanks in advance if some one can help me.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Making a comparison report in Excel

by Peyison In reply to Making a comparison repor ...

Don't think there's an easy way to do this without writing some VBA code. This would be pretty simple to do - let me know if you're interested. You could create a new worksheet function that you could use in the Result column just like other built-in worksheet functions (e.g. =Sum() ).

Hope this helps.

Collapse -

Making a comparison report in Excel

by lathe In reply to Making a comparison repor ...

I would like to know more info please. My e-mail address alatheef@emirates.net.ae

Collapse -

Making a comparison report in Excel

by C_M_S In reply to Making a comparison repor ...

Hi there,
Here is a possible solution to your problem.
In cell E7 put a, F7 b, etc. Should look like this when done

a b c e Result
2 3 1 4
3 1 4 2
4 2 3 1

Now in I8 put this formula:

=Offset($D$7,0,Match(Min(E8:H8),E8:H8,0))

Once entered use the AutoFill handle to drag the formula in I8 down as many rows as you need. You will, of course, need to adjust the cell references to meet your requirements.

Luck,
Mike

Collapse -

Making a comparison report in Excel

by lathe In reply to Making a comparison repor ...

I tried these formula and it is not working, can you please send me the excel sheet in alatheef@emirates.net.ae

Collapse -

Making a comparison report in Excel

by C_M_S In reply to Making a comparison repor ...

Sir,
As per your request here is my second posting. I am happy to have been of help.

Mike

Collapse -

Making a comparison report in Excel

by lathe In reply to Making a comparison repor ...

Thanks again.

Collapse -

Making a comparison report in Excel

by lathe In reply to Making a comparison repor ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums