Mailing List By Street
Increased cell reference in Excel?
I work with an Excel spreadsheet. This is a list of names and addresses clients. All information is in column A. In trying to make a mailing list, but the information should be disseminated. say the name is in Column B Street is in column c, and the city would be in column d. How can I make a formula for the cells gradually refernence I want, because the information in the column at regular intervals. Here's an example, a street of the city 2 3 4 5 6 7 city name 8 9 10 11 street name of 12 streets of the city, 13 so that I would refer to cell A1 B1, B2 and then reference the A6 and A11 reference b3 and so on, if you need to increase by 5 reference. I need a formula that can drag down and fill the rest or the blade, because I work with over 4,000 names and do it by hand is tedious
since it is consistent and start row1, Use the () and line () to concatenate indirect forms of text and formulas for calculating the cell # with simple math (I use a lot) B1 is this formula = INDIRECT ("A" & (ROW () -1) * 5 +1) c1 = INDIRECT ("A" & (ROW () -1) * 5 + 2) = d1 obtained INDIRECT ("A" & (ROW () -1) * 5 +3) , can fill down.
Grey Street – Dave Matthews Cover