address()

Hi everyone, I am trying to replace part of a formula to make it more dynamic. To do this, I am replacing $B$10 with INDIRECT(ADDRESS(ROW(D15)-MOD(ROW(D15)+4,7),COLUMN(D15)-MOD(COLUMN(D15)-2,3))) Now, ADDRESS(ROW(D15)-MOD(ROW(D15)+4,7),COLUMN(D15)-MOD(COLUMN(D15)-2,3)) = $B$10. But replacing...

So I now have a small business that uses cash accounting. Since I don't need much in the way of accounting, I use an Excel workbook for the numbers. Overtime I needed to see sums and averages based on time--7 days, 30 days, etc. To accomplish this, without using the dreaded--for me--VBA, I used...

Hi, I'd like use a formula that returns the address (or the row+column numbers) of the max value in a range (e.g. AD88:BA118). All the cells in the range contain numbers. I've tried this formula: =ADDRESS(MAX((AD88:BA118=N128)*ROW(AD88:BA118));MAX((AD88:BA118=N128)*COLUMN(AD88:BA118));4)...

Hi I might be going about this the wrong way but here goes. I have a column of dates in A as the first column in a larger table of data. I have a summary of the data in a separate table which feeds into a chart. For example =PERCENTILE(D16:D6855,0.9). I want to set a start and end date by...

Is there a way to get the column letter (in A1 notation) of the active cell, as opposed to its number (from R1C1 notation). =ADDRESS(5,10,4 ) returns row and col in A1 notation, but getting just col is a parse job My sources of column number (R1C1) Formula: =Column() Code: MsgBOx("active...