Timeline for Brute force looping & formatting Or Create Union range & Format? Which is efficient and when?
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 18, 2019 at 6:00 | vote | accept | Ahmed AU | ||
| Aug 17, 2019 at 6:01 | answer | added | TinMan | timeline score: 4 | |
| Aug 4, 2019 at 21:53 | answer | added | Mikku | timeline score: 1 | |
| Jul 26, 2019 at 2:18 | answer | added | Ahmed AU | timeline score: 0 | |
| Jul 26, 2019 at 2:17 | history | edited | Ahmed AU | CC BY-SA 4.0 | deleted 3157 characters in body |
| Jul 26, 2019 at 2:03 | history | edited | Ahmed AU | CC BY-SA 4.0 | added 3395 characters in body |
| Jul 25, 2019 at 23:39 | comment | added | Ahmed AU | @PeterT, Many Thanks for going through the tiring question and prompt response. I wll go through all the links and come back. | |
| Jul 25, 2019 at 20:56 | comment | added | PeterT | This Excel reference page implies that the Union limit may be 2,147,483,648 cells (see "Noncontiguous cells that can be selected"). But I'm not convinced that is the correct number. In any case, I completely agree with the other answers on SO that the correct approach is conditional formatting. | |
| Jul 25, 2019 at 20:54 | comment | added | PeterT | There are a variety of resources to review limitations of the UNION function. It looks like the post on SO was possibly based on this site, and it's instructive to review the limitations lower down on that page. Also, Craig Pearson has an excellent updated ProperUnion function that addresses many of the limitations. | |
| Jul 25, 2019 at 12:45 | history | edited | Ahmed AU | CC BY-SA 4.0 | edited title |
| Jul 25, 2019 at 9:32 | history | edited | Ahmed AU | tag added | |
| Jul 25, 2019 at 8:10 | history | asked | Ahmed AU | CC BY-SA 4.0 |