Re: Help with Array formula?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Infinitogool" <infinitogool@xxxxxxxxx> wrote in message news:O1eOR%23N%23IHA.4320@xxxxxxxxxxxxxxxxxxxxxxx
Hi Victor

you could try this, array-entered, E1:
dates: A1:B100
=MAX(($A$1:$A$100=D1)*$B$1:$B$100)

Copy down as far as needed

Very many thanks to both of you.

Biff - I have used your formula and it works perfectly. I also used conditional formatting to hide the unwanted zeros.

V

.

Relevant Pages

  • Re: Error Handling #N/A with AVERAGE Function - Average of values in Row
    ... He has a habit of doing that! ... Biff ... > I have a spreadsheet with an Array entered Formula (based on Rows using ... > with Conditional Formatting. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Change text color
    ... Biff that worked perfectly. ... > Use conditional formatting ... > Select the cell(s) in question ... > Set the font color to GREEN ...
    (microsoft.public.excel.misc)
  • Re: If color in a then value in b
    ... Biff Wrote: ... > Use the same logic that you used to apply the conditional formatting ... > "Desert Piranha" ... >> Desert Piranha's Profile: ...
    (microsoft.public.excel.misc)
  • Conditional formatting based on text
    ... Conditional Formatting ... Biff ... I've been struggling with this next request. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Error Handling #N/A with AVERAGE Function - Average of values in Row
    ... An alternative to the solutions provided by Biff and Don would be to ... there would be no need to use conditional formatting. ... > AVERAGE of the values in each Row excluding those cells with #N/A from the ... > calculation. ...
    (microsoft.public.excel.worksheet.functions)