Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
lovely_pink la Simpatie.ro
 | Femeie
24 ani
Bucuresti
cauta Barbat
26 - 49 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
Source:
https://www.excelforum.com/excel-genera ... value.html
In range B3:B24 user has 2 Card numbers - 56035 (B3:B9) and 78733 (B10:B24)
In range C3:C24 user has various dates
In range D3:D24 user has various hours
In range E3:E24 user has various amounts
He wants to display the amount for the latest date and latest hour for each Card number.
So this requires a 3 condition INDEX-MATCH array formula (activate with CTRL+SHIFT+ENTER).
In G3 I introduced 56035
In G4 I introduced 78733
In H3 I introduced the following formula (activated with CSE), then dragged it to H4:
=INDEX($E$3:$E$24;MATCH(1;(G3=$B$3:$B$24)*(MAX(IF($B$3:$B$24=G3;$C$3:$C$24))=$C$3:$C$24)*(MAX(IF(($B$3:$B$24=G3)*($C$3:$C$24=MAX(IF($B$3:$B$24=G3;$C$3:$C$24)));$D$3:$D$24))=$D$3:$D$24);0))
See source for excel file.
_______________________________________
|
|
| |
|
