Get instant live Excel expert help with ROW Functions

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi team. would like to figure out how to cross reference information from a column to a row.
Solved by F. H. in 15 mins
In the loading sheet, The calendar sheet is used as a reference to start the calculations in the "count down" sheet My formula lookup up a reference values and then adds the corresponding "countdown sheet" values. Row 3 works perfect because it in in the match is found in the first column, column. Row 4 finds its match in the second column, because of indexing I loose I set of data, the total row values should add up the values in column "B" Rows 4,5,6 etc each loose an additional column can u please help
Solved by K. S. in 24 mins
I am trying to link a checkbox from a list of vendors that will highlight an entire row. Highlighting must be based off of vendor listed for material and status of red flag showing material needing to be ordered. The idea is to have purchaser click the vendors checkbox and it highlight all material needing to be ordered through the list for that vendor. See attached sheet. Example. If K1 is checked then Row 8 should be highlighted. Thank you.
Solved by C. C. in 14 mins
Is it possible to lock Cell A1s width, and then be able to adjust A2- A50s width to somthing different? Thats just an example, under the months, i would like to to have a cell/cells the same width as row 1, but be broken up into for boxes (or cells) so that I can mark each box for a week that somthing is due that month.
Solved by X. D. in 20 mins
I am trying to create a semi-automated spreadsheet to keep track of the tv we watch in the family home. Please find attached the screenshot of the breakdown. I am trying to create a rule for cell Y2 I want the cell to turn Green if the following are true: one or more cell in the row contains a date that is less than or equal to the current date and/or one or more cell contains the word "Saved" and to turn red if NEITHER of the above are true (ie all the cells in the row contain dates after the current date and/or the word Watched" So in this instance, Y2 would be green, but if cell S2 said Watched it would turn red. Thanks!
Solved by X. H. in 13 mins
I have entered a data validation drop down box which when active is chosen it turns green and inactive turns red using conditional formatting. However how can I make this colour change apply to the whole row based on the choice of Inactive or Active? Please refer to F6 on the Woodside Tables tab on the attached excel document.
Solved by C. D. in 12 mins
Hello, Having issues with a SUM formula. I have a row of data C48:N48 that i need to SUM in sheet 'ABC Costing' The data between C48:N48 is based on drop down menus from sheet 'Quote' so some cells are blank and some have values but this changes based on selections from the drop down menus. What formula should I use in sheet 'ABC Costing' cell R48 to SUM C48:N48?
Solved by I. W. in 30 mins
I have two columns of dates, and I need to apply a conditional formatting rule so that; If a date in Column B falls within 0-3 months of the date in Column A (same row), it highlights Green If a date in Column B falls within 3-6 months of the date in Column A (same row), it highlights Yellow If a date in Column B falls within 6-12 months of the date in Column A (same row), it highlights Red
Solved by X. S. in 25 mins
I'm trying to record a macro that will create a pivot table. I want the pivot table to display the "division" field name in both the row and values section of the pivot table so that it outputs the number of teams in each division. For example: Advanced: 15 Intermediate: 20 Beginner: 5 After I record the macro and try to run it I get the error message - Run-time error '1004': Method 'CreatePivotTable' of object 'PivotCache' failed This is what the VBA looks like: Sub Macro1() ' ' Macro1 Macro ' ' Sheets.Add ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "2017-USA-Spikeball-East-Tour--P!R1C1:R51C40", Version:=xlPivotTableVersion14 _ ).CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:= _ "PivotTable1", DefaultVersion:=xlPivotTableVersion14 Sheets("Sheet1").Select Cells(3, 1).Select With ActiveSheet.PivotTables("PivotTable1").PivotFields("division") .Orientation = xlRowField .Position = 1 End With ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _ "PivotTable1").PivotFields("division"), "Count of division", xlCount End Sub
Solved by V. A. in 22 mins
i put a formula in a cell i want it to repeat by filling it down in the column but it keeps repeating the sum of the original number instead of recalculating the new row of numbers???
Solved by C. J. in 22 mins