I am the least Excel-savvy person I know. Thank you so much for explaining this in a clear, step-by-step basis and providing the cut and paste code. I'm grateful.
This is great! now what if I had in one the cell and inside was a number 113 and next to it B17 and I wanted to not factor in or not see the B17 and was summing in another cell?
Hi, Thank you for this video. I've save it as instructed, but it still losing the module. Please let me know what I'm doing wrong. Happy New Year. Thank you
Dear Chester, that was amazing. I am wondering if a cell consists of multiple values separated by forward slash (/) e.g. INC00001 / INC0002, how do I get the actual count of the values (here in this case, there are 2 values ina single cell) without applying delimeter? Is there any way I can get the actual count as 2 please? Looking forward hearing from you. Thank you!
Question, if I have in cell A1 the number 15 and want to add 4 to the same cell is there a way to go to that cell (A1) type in the number 4 and have the sum of 19 come up when I hit enter?
Hi Chester how can i copy it with string in excel version 2016? Ex: Client Name : Smith, Simon . I want to copy only the part Smith, Simon. Thanks a lot
is this possible? row A has the quantity example (30) row B has numbers separated by commas, example (2.500,3.500,2.450,5.235) Row C has numbers separated by commas, example (2.500,3.500,2.450,3.650) this is the formula that I have that gives me the totals for both rows in row D. =SUM(VALUE(CELLSPLIT(B2,",")))+SUM(VALUE(CELLSPLIT(C2,","))). I would like to that the total in row D and multiply that by the quanitity of row A. I cant find a fix for this other than putting a formula in row E, example (=d2*a2). is there a way to add that multiplication formula to the formula that already exists in row D? if you can shed some light I would be appreciative. Michael
I am the least Excel-savvy person I know. Thank you so much for explaining this in a clear, step-by-step basis and providing the cut and paste code. I'm grateful.
Hi Chester, Super great video . This is what I am looking for. You make our lives much easier. Thanks millions. Thumbs up as always
Super video. Thank you for the two explanations. I didn't know Split in VBA. Very useful. Thank you Chester.
This is great! now what if I had in one the cell and inside was a number 113 and next to it B17 and I wanted to not factor in or not see the B17 and was summing in another cell?
Thanks Chester. Helped me
Hi, Thank you for this video. I've save it as instructed, but it still losing the module. Please let me know what I'm doing wrong. Happy New Year. Thank you
Great stuff.
thank you sir
Dear Chester, that was amazing. I am wondering if a cell consists of multiple values separated by forward slash (/) e.g. INC00001 / INC0002, how do I get the actual count of the values (here in this case, there are 2 values ina single cell) without applying delimeter? Is there any way I can get the actual count as 2 please? Looking forward hearing from you. Thank you!
Does anyone know how to replicate this in google sheets?
Question, if I have in cell A1 the number 15 and want to add 4 to the same cell is there a way to go to that cell (A1) type in the number 4 and have the sum of 19 come up when I hit enter?
Is there a simple way to just sum numbers as I add them to a single cell? eg if I have 10 in a cell and I then enter 2, it should then show 12
Hi Chester how can i copy it with string in excel version 2016? Ex: Client Name : Smith, Simon . I want to copy only the part Smith, Simon. Thanks a lot
is this possible? row A has the quantity example (30) row B has numbers separated by commas, example (2.500,3.500,2.450,5.235) Row C has numbers separated by commas, example (2.500,3.500,2.450,3.650) this is the formula that I have that gives me the totals for both rows in row D. =SUM(VALUE(CELLSPLIT(B2,",")))+SUM(VALUE(CELLSPLIT(C2,","))).
I would like to that the total in row D and multiply that by the quanitity of row A. I cant find a fix for this other than putting a formula in row E, example (=d2*a2). is there a way to add that multiplication formula to the formula that already exists in row D?
if you can shed some light I would be appreciative. Michael
Does it work, if your values are separated by Alt Enter in a cell, meaning the numbers are stacked in a cell?