Get instant live Excel expert help with ROW Functions

What I am needing may be difficult to put into words, But I have a list of products that we are making for my job. There is one column that says complete, when this column has a value (date) in it, the total complete for that specific product to subtract the amount in that row from the total products needing to be produced.

I am creating a basic program of work. I have the task duration in one column and would like the corresponding number of cells to be highlighted in the adjacent row. For example I would like 3 cells to be highlighted if I input 3 into the duration cells. Is this a combined IF statement with the cell highlighting rules? Hope someone can help. Thanks in advance

how do i fit everything in one row? when i try to print the worksheet, it prints it off.

I need a formula that bold's one row of text A2 to F2 and I need to also put a border around A1 to F12

I am looking for a way to use the filter on multiple columns, but not necessarily in one full row, ie Row 3 Columns A, B, E, & G. Is this possible?

I have an export from a database. The export has two levels: cases (unique) and records (not unique). So 1 case will have many records. The unique cases are on one sheet, then the records are on another sheet. The sheet with the records will have duplicate case ids becuase there are multiple records for 1 id. There are many columns of other data. This other data is exporting from various fields. The fields are exporting either blank/null or with data. I need to merge the multiple rows for 1 case id into 1 single row, keeping the data within each column.

Hello, I am trying to use a formula across a google sheet. Example: Column C has this formula: =Sumproduct('Volume and SL'!$O4:$O10,'Volume and SL'!$C4:$C10)/SUMPRODUCT('Volume and SL'!$C4:$C10). The each row 5 -57 look like that only the numbers change to reference a different cells on another page. I need to use that same formula in Column G but I need to have the Column letters change. Example: =Sumproduct('Volume and SL'!$P4:$P10,'Volume and SL'!$D4:$D10)/SUMPRODUCT('Volume and SL'!$D4:$D10). Any suggestions? Do you need more informtion?

I have formulas in a workbook (WB1) that pulls numbers from cells in a separate workbook (WB2). The numbers have been changing in WB1 because the cell number in the formulas have changed to different cells in WB2. Row do get added from time to time in WB2 but when test this my formulas in WB1 are unaffected. I am stumped. example of the fomula ='[1-Master Calc Sheet - CDN Supplier.xls]Sheet 1'!$P$2215

I am looking for google sheet conditional formatting custom formula! What I would like to do is highlight the lowest cost in my range cells from U7 to BV311 and have it equal to lowest quoted price in row Q in one action. However, I am forced to go line by line with the conditional formatting : Highlighted Cell Rules --> Equal to --> =$Q$56 with (Custom format). Can you please help me to streamline this process? I have 250 more lines to go!

I have a spreadsheet where row 1 is dates, spanning 3 columns each. Columns A-C are Product Name, Order #, and Case Count, respectively. D-F (repeating indefinitely) are Sold, On Hand, and Order, respectively. I want a dynamic formula applied to the whole sheet that checks row 1 for today's date and the order column for quantities greater than 0. Currently, I have =AND(A$1=TODAY(),C>0) and it works as expected. The problem is, it's formatting cells in the wrong column (relative A as opposed to relative C). Is there a way to alter this so formats relative column C?