urgent help needed

Hi, I need a way to get around this error because I need this formula to work in the next few days. The formula is as follows: =CONCATENATE(LEFT(B11,FIND(",",B11,1)-1),"...

Hi, i am am trying to return the value of a cell if another cell equals text for example in cell a1, if cell b1 = 'yes' then return the data in cell c1 into cell a1 if that makes sense? thanks in advance

<tbody> <colgroup><col span="2"><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody> 1 How Have You Been? Receptive communication Dialogue (2) Unit 1, Lesson 5 Michelle Lapides, Kenneth Ness, Andrew Weidig x 168 Role-Shifting Three Characters: Me explain do-do...

Hello, I am working on a formula that has many nested IF statements. I am calculating distances from stores, where the distances are in a matrix. Here is a short version of the formula to get from store to store...

I have two spreadsheets that have stock information for two departments, "Goods in" and "QC". I am trying to update the "QC" sheet automatically from the "Goods in" sheet. When a date is inserted into the "Goods in" sheet (column w) the "part no (j)", "quantity (k)" and "date released (w)"...

Hi, New here, reasonably new to excel so apologies if I am a little unclear in my explanation of what I'm needing. I have exported a database file that lists each individual transaction that I have processed in my shop over the past 12 months (over 10,000 rows), each transaction row lists...