1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How Do I Get Excel To Display A Reference # based on the number of entries?

Figured out how to do it: Couldn't get a rounding function and row function to work in the same cel, so I created a hidden column to generate the row separately and then a function using roundup and division to create the page number in the column I want it to appear in.

I have a report that I am working with that prints out with 39 entries per page and I want to have a page reference in Excel so I can find something quickly in the printed report. How do I get Excel to generate a number so that fields 1-39 in column A, read as page 1 in column B, fields 40-78 read as page 3 etc...

Further information: These reports can be anywhere from one page to 200+. What I'm trying to do to improve work flow is to get a sheet that can figure the page reference automatically when I enter the data into it.

submitted by /u/Fickle-Aardvark6907
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#row zero
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#cloud-based spreadsheet applications
#Excel
#reference number
#page number