esProc Desktop's Blog

esProc Desktop's Blog

Follow

Follow

#129 — Multiple Column Association

#129 — Multiple Column Association

Problem description & analysis: Here below is a data table: Task: Compare the values of M, N and O of each row in Sheet1 with the corresponding values in Sheet2. When the row that has the same values is found, return the House value of this row, an...

esProc Desktop

#128 — Use Formulas to Handle Association in Excel

#128 — Use Formulas to Handle Association in Excel

esProc Desktop

#127 — Concatenate Data Within Groups into Text

#127 — Concatenate Data Within Groups into Text

esProc Desktop

#126 — Group When Encountering Non-Null Values

#126 — Group When Encountering Non-Null Values

#125 — Grouping Upon Encountering Blank Rows

#125 — Grouping Upon Encountering Blank Rows

#124 — Take Adjacent Data as Grouping Criteria

#124 — Take Adjacent Data as Grouping Criteria

#123 — Convert One-Dimensional Array to Two-Dimensional Array

#123 — Convert One-Dimensional Array to Two-Dimensional Array

#122 — Put Every N Members in a Group

#122 — Put Every N Members in a Group

#121 — Enumeration Grouping

#121 — Enumeration Grouping

#120 — Group by Segment

#120 — Group by Segment

#119 — Group by the Expression

#119 — Group by the Expression

#118 — Group by the Combination of Multiple Columns

#118 — Group by the Combination of Multiple Columns