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: bruneta_ta_us pe Simpatie.ro
| Femeie 25 ani Giurgiu cauta Barbat 25 - 52 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
Source:
Question was asked there and I answered with the solution below.
User had a Summary sheet (see image below) and wanted to display X if value is found in the sheet which name is in cell A2.
Summary sheet:
Sheets 123 and 456 both contained months in range A1:A12 and values in range B1:B12.
The formula below returns X if there is a value in 123 for month January, February etc. The formula can be dragged down and right for as many sheets as required.
_______________________________________
|
|
pus acum 4 ani |
|