Excel Titan

Excel Titan

Knowledge should be shared freely, not hoarded.

Recent posts

Repeat Values N Times

less than 1 minute read

Here is a method to repeat the values in Column ‘A’, (n) number of times required in Column ‘B’ outputting the results in Column ‘C’. The Formula is an Array...

Put A Row Number On A Table

less than 1 minute read

Here’s a simple way to get the row number of the table items. It’s a simple formula referencing the current cell’s row minus the row number of the table head...