Comments by Member 14019423

Member 14019423 9-May-22 12:25pm View

Actally.I have a table that has derived city,State and Zip columns from the address column however it is based in eventname column called "in" and "out"

Example.
Id. "Address" city. State. . Zip. Event

1. 4 drive rd phoix Arizona 34445. Phoneix. Ar. 34445. IN

1. 5 drive rd almx Missiippi 34445. Phoneix. Ar. 34445. Out

Ids are same so have to pick the address based on eventnames

Member 14019423 21-Jan-21 16:12pm View

How do I implement the following formula on the entire excel sheet for column a and B with equal spacing

="Tag #"&INDIRECT("'Tag Info'!N"&CELL("row",A42)/21+1)

After spacing 64 row ="Tag #"&INDIRECT("'Tag Info'!N"&CELL("row",A1008)/21+1)

How to implement to the entire sheet?

Member 14019423 20-Jan-21 15:50pm View

Yes I have tried various things however the information keeps shifting downwards as the print page preview moves from page 1 to 2 to 4 and so on

Member 14019423 20-Jan-21 15:08pm View

I have 2 columns A and b information of 500 rows

Comments by Member 14019423 (Top 4 by date)