Timeline for why is one row skipped when including ranges from two sheets
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 27, 2015 at 11:06 | comment | added | Rubén - Volunteer Moderator -♦ | It´s up to you. In the example formula, using (Col1<>'' AND Col2<>'') will exclude those rows where one of the columns has data but the other not, so row 3 and row 5 of source data 2 will not be include because of the filtering criteria. | |
| Aug 27, 2015 at 10:20 | comment | added | Chris Morris | Should it be an AND and not an OR? This assumes that I don't want to include rows that have blanks in either of those columns. | |
| Aug 27, 2015 at 10:19 | vote | accept | Chris Morris | ||
| Aug 27, 2015 at 0:18 | history | answered | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |