# Software

## General discussion

Locked

### Making a comparison report in Excel

By ·
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.

Thread display: Collapse - | Expand +

Collapse -

### Making a comparison report in Excel

by 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 In reply to Making a comparison repor ...

Collapse -

### Making a comparison report in Excel

by 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 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 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 In reply to Making a comparison repor ...

Thanks again.

Collapse -

### Making a comparison report in Excel

by In reply to Making a comparison repor ...

This question was closed by the author

## Related Discussions

• 1

trederedet ·

• 3

#### What is SDLC? Phases of Software Development, Models, & Best Practices

jmirthipati ·

• 11

#### What is the best AI Chatbot for ecommer website

curiousmuch ·

• 2

#### What are some qualitites of POS system?

pinesucceed21 ·

• 7

#### How to convert MKV files to MP4 in a fast, simple and free way?

starry325225 ·