Search results

Hi Chirayu, That looks awesome. Is there a way in columns L & M I could remove "total quotes" and 279, as the grand total is adding total quotes and total doors values. Also in columns P to R, is there a way to remove "total orders", 294 and £122652.42; as this is adding to the values from...

Hi Chirayu I tried your method, but I think I got the whole thing wrong. The pops up referred to, didn't pop up for me. I've attached the actual file so you can see what I'm trying to achieve You'll see the yellow highlighted columns is what I'm trying to achieve, with my pivot tables to the...

Hi Bosco, Thanks for getting back to me. That seems to work just fine, so thank you so much for your help Really is much appreciated Regards Brian

Hi Chirayu Thank you for the sample sheet I think I've done something wrong, as you'll see my table next to yours, when I was trying to duplicate it. (sheet attached) The table isn't spread over as many columns as yours. Could you let me know what I did wrong please. Regards Brian

Afternoon all I've attached a quick sheet for reference. I have a list of sales people, the method the order was placed, qty. of orders, and value of orders I'm trying to summarise how many of each order type, each sales person has sold, and the value for each order type each person has sold...

That's excellent Bosco, Worked a treat, thank you so much. Regards, Brian

Hi Bosco Thanks for getting back to me. I really wanted the result to be in cell G2 If the word C/lock from cell B2 appears in the list E2:E29, I wanted cell G2 to copy the number from cell C2 If the word doesn't appear in the list, return zero instead in cell G2 Regards Brian

Afternoon all, Hoping you can help with this one I want to search a list for a set word. If found I want to pull the value from a specific cell I've attached a sample sheet as an example Thanks all Brian

Afternoon Hui, That is excellent. Thank you so much for your assistance, it's much appreciated Regards Brian

Morning all, I'm trying to find a formula that will return mulitple values in a search. For example, if I search for a keyword in one column; how to return each cells content that matches the search word I've attached a sample sheet so you can see my problem. Regards Brian

Thanks Peter, I opted for the simpler solution in the end, but yours was certainly imformative, Thank you Regards Brian

Hi Chirayu That is excellent. Thank you so much for yur help. Regards Brian

Good afternoon I have a sheet that has order dates in column A, then column B has the lead times In column C it shows the due date. I'm looking for the formula to change column C, both 5 working days and 8 working days after the date in column A Your help would be much appreciated Sample...

Hi all, I have a sheet with six columns of data I want to try and list all the possible combinations, using information from each of the six columns I've attached a sample sheet so you can see what I mean, I want to list all combinations in column J Many thanks Brian

Hi Hui, Thank you so much for coming back to me. I think I've confused myself. I've attached the sheet again showing where I'm confising myself. Regards, Brian

Hi all, I have a formula on a sheet that pulls information from a cell in a seperate sheet. I make many of these seperate sheets which are stored on my pc. I'm hoping to find a way of replacing the number in the formula, to correspond with the ref. number in the adjacent cell. I've attached...

Thank you Chirayu That was most helpful. Really appreciate your help. Regards Brian

Hi, Thanks for getting back to me. Yes the columns are years (sales periods) I'm trying to do a graph for units over the ten years, and a seperate graph for t-over for the same 10 year period. Appreciate any input you can offer. Regards. Brian

Afternoon all, I'm trying to make a line graph that will chart up to 10 years of sales. I've attached a sample sheet. The first tab "units" shows the 52 weeks which need to be recorded, then there are 10 columns which will chart the 10 years records. The second tab "t-over" shows the 52...

Hi Bosco, Thank you for your help, but i think the mixed text/numbers caused an issue Much appreciated. Regards, Brian

Thank you so much, Worked a treat. Much appreciated. Regards, Brian

I've uploaded a sheet to show what I'm struggling with. Thank you guys, Brian

Hi Derek, Would you be able to add the same iferror to the formula below please. I've tried doing it based on the earlier one you sent, but can't seem to get it to work =SUM(($N115+$N116)/$N120)*$J114 Regards Brian

Hi Derek, That worked a treat. Thank you so much. Much appreciated. kind regards, Brian

Hi all, I'm tring to add an iferror to the formula below =O120-N117-(($N$2/$N121)*S114) I wan't to avoid getting #DIV/0! in the result I would rather return a zero if there's an error, instead #DIV/0! Regards, Brian