excelisfun

:banghead::banghead::banghead: I came across an excelisfun video a while ago in which a lookup was used that showed all values in one cell. VERY similar to the textjoin(), but it worked in 2010. ....and of course, I can't find it, nor do I remember what I searched when I stumbled upon it...

Hello Everyone, My question is that; I work on an excel file which have a high number of columns. My work requires me to have data visible in far left side columns, when I work on the far right side columns. Is there any way to sort this problem, screen shots or something??? Warmest Regards,

Hey, currently doing Slaying Excel Dragons homework problem 84 which involves using advanced filter. As you can see, I want to set the criteria to Jo OR Fred but the result is also including "Joe" which is Jo plus an "e". Why is excel doing this and how do I stop it?

Hi Guys: Im trying to build a fairly basic calculator but I need to use 1 cell twice with 2 functions. Does that make any sense??? My problem lies in cell C8 Here are my formula's =SUM(D3/(A8*10)) This one is in C8 And this one uses C8 =SUM(C8*A8)*10 but is in D8 =SUM(D3/(A8*10)) gives me...