flexible

I have a table with one column A with several lines. The number of lines in column A varies from time to time. I wrote a macro (see below) that will write a formula in B1 and drag it down from B1 until the last used cell in column A. In the attached macro the range is limited until B6. How can...

Let say I would like the first three tic 5 units aoart and the next 3 10 units apart. Is this possibly done ? Really appreciate the help.

Hi All, I am currently operating with the current formula: =(J12-MIN(IF($B$12:$B$172871=B12,$J$12:$J$172871)))*K12 + CTRL,SHIFT,ENTER I thought this change would make the formula flexible for any length of columns: =([@Name4]-MIN(IF([Groupid]=[@Groupid],[Name4])))*[@Name5] But it doesn't...

Hi all, I would like to make a template in Excel to record a Root cause analysis. Do you think that this is possible? In my mind I imagine a basic Excel spreadsheet with a number of boxes, pre-established across the top of the sheet. Each box allows text to be inserted as normal but also has...

If you need to name a range in a spreadsheet, you would normally highlight the cells and type a name in the name box on the top left corner. But what do I do if the range needs to be flexible? In cell A1, the user specifies an integer, say 10. I want B1:B10 to be named "user specified range"...