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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
AlexandraPopa la Simpatie.ro
 | Femeie
25 ani
Bucuresti
cauta Barbat
25 - 39 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2247
|
|
Source:
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.
_______________________________________
|
|
| pus acum 5 ani |
|