How Do I Get Excel To Display A Reference # based on the number of entries?
Our take
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Referencing values on another sheetHi, Im quite new to excel and can't figure out how to reference values on another sheet. I have some sums and countifs on Sheet 1 and they all total up to lets say 500. How do I get a cell on sheet 2 to display this number without just typing it myself? submitted by /u/Intelligent_Let7166 [link] [comments]
- Fill out a ranking using data from other pagesHi everyone, I'm not a particularly frequent excel user, and I'm making a silly spreadsheet documenting the reviews my Australian friend is giving to British crisps. Each crisp has a picture on the home page, which when clicked takes you to the individual review of the crisp. She has ranked each crisp with different categories and given it an overall rating. I would love for each "overall rating" to go to a final page on the spreadsheet which shows all the crisps in ranking order. Now, of course I could just go through and type them in, changing them each time she reviews a new crisp, but is there a way excel can take this information with a formula? For example, on each individual crisps page the overall rating is cell D8. If a quaver was rated 8.5, a pombear was rated 6 and a mini cheddar was rated 7, could excel automatically put them in order of quaver, mini cheddar, pombear on my final ranking page? I appreciate this is a very long winded way of getting it across but it's a bit niche and so I wanted to try and make it clear! (It's much easier to just show someone a video of the spreadsheet but I don't think I can do that here!) Thanks!! submitted by /u/puzzled_puzzler12 [link] [comments]