“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I seem to have locked my spreadsheet, as far as arrowing down and across. The whole spreadsheet arrows across or down, not the individual column or row.

Solved by X. A. in 13 mins

I have a table where some rows are hidden, although perhaps not in the technical definition of "hidden." Where a row is not shown (which you can tell by the row numbers), there are two separator lines between the row numbers, very close together, as opposed to one line between two rows in sequence. Nothing I have tried to unhide these rows, including all the techniques suggested in "Help," cause these rows to be visible.

Solved by T. E. in 11 mins

What formula do I use to search for a particular row for an event and when the criteria is found, calculate items in the column below? Example:
Row 5 contains the sales price of a building ($1,500,000) in a cell between Columns M and X; the calculation needs to find the cell containing $1,500,000 and then calculate the the NOI contained in the Rows 20 - 30 in the same Column as the cell containing $1,500,000.

Solved by I. B. in 25 mins

I have trying to find a way to enter in an item number (A0001) 3 times in that row. Like:
Row 1 - A0001
Row 2 - A0001
Row 3 - A0001
Row 4 - A0002
Row 5 - A0002
Row 6 - A0002

Solved by F. Q. in 17 mins

I have created a audit in excel with column A frozen with the questions in, the following columns i have added data validation with drop down answers to the questions. in row 2 i have a sequential weekly date beginning on 05/06/2017. i also have multiple pages with the same parameters in but different names for the worksheets. i would like to create a pivot table pulling 1 months worth of data from each worksheet so i can quickly scan the results of each worksheet

Solved by Z. S. in 15 mins

i have an excel worksheet I had to modify. I added columns to the right and they are not wrapping to the existing columns.
My formulas are correct. The client wants " Please format report for landscape, narrow margins, wrap test, and great row height so this prints better. Also any formulas that are "#VALUE" instead of a workable formula"
I have no idea what he is talking about. Thanks for help

Solved by M. F. in 24 mins

i got disconnected from my last session. I think the spreadsheet is fixed. GBUT i need to
1)Know how to make it print on one landscape page
2) how to download it back to my computer
3) i have 7 other sheets to do. Can i do them or can I up load them for you to do
The client wanted "Please format report for landscape, narrow margins, wrap test, and great row height so this prints better."

Solved by I. J. in 20 mins

Hey there - I am trying to populate a sheet using data on another sheet, and I want to populate it by a certain number on the second sheet. I.e., I have a row of an address, and I need that address to populate 11 times, and 11 is a sum of an existing formula on a secondary sheet. I'm stuck somewhere between VLOOKUP, Array formulas and Macros.

Solved by M. W. in 12 mins

In a workbook, I have two sheets. On Sheet 2, I have a list of locations in Column 1 and a list of Locations in Row 1, and the distance between the two locations is at the intersection.
In workbook 1, I have it set to in K1 to choose a dropdown option which corresponds to the name of a location from Sheet2Column1, and K2 is set to choose a dropdown which corresponds to the name of a location from Sheet2Row1. I want K3 to give me the value of the intersection between those two points.
So, ideally, if in sheet 2 at the intersection of Bangor and Old Town the value listed was 25, On sheet 1 I would want to be able to pick Bangor, Pick Old Town, and have it tell me 25.

Solved by X. W. in 27 mins

My goal is to pull data from a specific row on one of 6 different worksheets by using drop downs. I have a drop down that indicates what "range" someone is in (these are the 6 different worksheets) and another drop down the (Current Grade) indicates where in that specific "range" worksheet to look for the data. I've dabbled with some of the formulas already, but am stuck on getting the data pulled in correctly / at all.

Solved by T. Q. in 22 mins