Formula Forensics No. 039 – Find the Cell Address for a value (2D & 3D Reverse Lookup)
Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)
Free 2014 Calendar, daily planner templates [download]
Here is a New year gift to all our readers – free 2014 Excel Calendar & daily planner Template.
This calender has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
2013 Calendar – Excel Template [Downloads]
Here is a New year gift to all our readers – free 2013 Excel Calendar Template.
This calender has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
Highlight Row & Column of Selected Cell using VBA
When looking at a big table of analysis (or data), it would make our life simpler if the selected cell’s column and row are highlighted, so that we can instantly compare and get a sense of things. Like above.
Who doesn’t like a little highlighting. So lets learn how to do highlighting today.
Formula Forensics 018. Retrieving the Nth number from a Range which has Gaps.
Over Easter, while we were all busy eating our Easter Eggs, at the Chandoo.org/Forums, Slk213 was worried about how to retrieve the Nth number from a row of data which had gaps in it.
Today in Formula Forensics we will look at how to solve this problem.
2012 Calendar – Excel Template [Downloads]
Here is a new year gift to all our readers – free 2012 Excel Calendar Template.
This calender has,
» One page full calendar with notes, in 4 different color schemes
» 1 Mini calendar
» Monthly calendar (prints to 12 pages)
» Works for any year, just change year in Full tab.
Go ahead and download the FREE 2012 Calendar and Enjoy.
Formula Forensics No. 005 – Zebras and Checker-Boards
Zebra Stripes and Checker Boards
This week in Formula Forensics I’m taking a break from Array Formulas to have a look at some Zebra Stripes and Checker Boards.
No, I haven’t gone crazy, although some may argue that point.
More specifically were going to take a look at, Zebra Stripes and Checker-Board Conditional Formatting.