Select Vehicle Code,last date in the month,oldest time on that date return Amount value

**munaaba** · 11-08-2019, 06:17 PM

I have four columns as shown below
Two vehicle codes 56035 and 78733
create a formula that can return the amount consumed by each car on the oldest date in the month,with the oldest time on that very date.

**FDibbins** · 11-09-2019, 01:08 AM

You should show some expected outcomes with this sort of question.

See if this is what you want. I put the Card No in H2...

	H
2	56035
3	1576200

H3=INDEX($E$3:$E$24,MATCH(MIN(IF($B$3:$B$24=H2,C3:C24)),$C$3:$C$24,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

**Mrrrr** · 11-09-2019, 05:56 AM

Say in G3:G4 you put your Card nums, in H3 put the following ARRAY formula (activate with CTRL+SHIFT+ENTER), then drag down to H4:

Formula:

Please Login or Register  to view this content.

Also done in attached file.

Select Vehicle Code,last date in the month,oldest time on that date return Amount value

LinkBack

Thread Tools

Rate This Thread

Display

Select Vehicle Code,last date in the month,oldest time on that date return Amount value

Re: Select Vehicle Code,last date in the month,oldest time on that date return Amount valu

Re: Select Vehicle Code,last date in the month,oldest time on that date return Amount valu

Thread Information

Users Browsing this Thread

Similar Threads

Autosum amount based on month and vehicle number with limit alarm

Return date against validating if the bill amount equals to payment and return a date

[SOLVED] Return the oldest date when cell does not contain an *(Asterix)

Return oldest date in range when a file is open

Return oldest date with some dates excluded

return oldest date based on call value

[SOLVED] Calculating contribution of sales by month with given amount, start date, and end date

Bookmarks

Bookmarks

Posting Permissions