it looks like you pasted that formula in every cell is that correct?
You can copy and paste or you can drag (grab the lower right corner of the cell with the formula and drag down or across. The formula will automatically adjust to each new cell.
VBA is Visual Basic for Applications and is the computer coding used to record macros. I did not use VBA so not to worry about that.
i'm confused on what you named table
I named the original data "Table" In order to do this, simply select all your data and then go to the name box (small white box in toolbar where you normally see the cell name (i.e A2)) and type Table and hit Enter. If you go to that box in the example I gave, there will be a dropdown where you can select Table and see what Table represents.
Actually, I think I made it more complicated than it needs to be. It is probably better to directly refer to the cells rather than use Table. The formula in A1 of Results would be
Then you don't need to worry about naming ranges or #Values, etc.
how about if i wanted to keep the corresponding dollar amount in there as well?
Then we need a more complex formula....
Starting in B1, dragged down and across (leave col A as is)
=IF(OR(LEN(A1)>7,AND(LEN(Data!B1)=8,LEFT(Data!B1,1)="7")),Data!B1,"")
That looks to the column to the left to see if it contains an 8 digit number then it pulls that number. You can't use this in Column A because there is no data to the left. You'll need to reformat as $.
Hope that helps.
Bookmarks