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

I have a table and want to find the average percent change in column T minus column V
when the value in column W is >0. This is the formula I have tried, but it just returns #VALUE.
=SUMPRODUCT((Data!W:W>0)*((Data!T:T)-(Data!V:V))/SUMPRODUCT((Data!V:V)*(Data!W:W>0))/COUNTIF(Data!W:W,">0"))

Solved by C. L. in 15 mins

Hi Please can you help me, on sheet COST and SELL I would like to multiply the cost by the % margin in column U, these vary as it goes down the page.

Solved by Z. W. in 13 mins

Please can you go to the Cost and Sell sheet, I need my cost priced to be increased by the % in column U

Solved by G. E. in 11 mins

Hi I have a spread sheet, containing 2 sheets.
On sheet 1, I have a column filled with text and numbers "BH140" for example. On sheet 2 I want to reference that cell so for example:
Sheet2A2=Sheet1A2
I want to increment linearly every second row on sheet 2 for example:
Sheet2A2=Sheet1A2
Sheet2A3=Sheet1A2
Sheet2A4=Sheet1A3
Sheet2A5=Sheet1A3
Can you please help me?

Solved by X. Y. in 29 mins

I have two Excel sheets, SHEETA and sheetB, in SHEETA I have a column A (Policy) which has more than one row of data (ERRORS)COLUMNC that belongs to the same policies, Now I want to copy all these errors in one cell in sheetB, where one of the column IN SHEETB has the same policy = sheetA column A
E.G.
Formula logic.
IF COLUMN A OF SHEETA = COLUMNA OF SHEETB THEN COPY AND PASTE DATA FROM SHEETA COLUMNC INTO SHEETB COLUMNC

Solved by G. D. in 26 mins

I'm trying to find how to multiply column name with number

Solved by V. D. in 24 mins

I need help on formula to combine column letter and a cell from row to get its value

Solved by Z. H. in 14 mins

I need to alter the current formula for columns J THRU M. So, rows 2 - 293 that have any value in columns F,G or H place the value of '1' in column 'M'. Concurrently any value placed in the 'E' column for rows 2 - 293 show "1", otherwise show a "0" for no value given.
Rows 294 - 398 that have any value in columns F,G or H place the value of '1' in column 'J'. Concurrently any value placed in the 'E' column for rows 294 - 398 show "1", otherwise show a "0" for no value given.

Solved by K. C. in 13 mins

I have a column I containing cells of different values; some of those cells are blank. I also have a separate column G that doesn't have any blank values.
What I'm basically trying to do is use VBA to fill in the empty cells in column I with the value of their adjacent column G cells.

Solved by T. C. in 11 mins

I am trying to use Index and Match to return the first date something was billed. Conversely, eventually I need to find the same for the last date. Right now, I am using a simple index match based on the row number, but if the activity changes, I need to validate the activity on Sheet 1 with the description on Sheet 2. There needs to be some logic in the formula to match the description to ensure it is looking up the correct row. Thus the logic would be, lookup/match the description in column A, then lookup and return the corresponding date for the first column within the corresponding row with a dollar value in it.

Solved by M. A. in 29 mins