Get instant live Excel expert help with COLUMNS Function

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

In the loading sheet, The calendar sheet is used as a reference to start the calculations in the "count down" sheet My formula lookup up a reference values and then adds the corresponding "countdown sheet" values. Row 3 works perfect because it in in the match is found in the first column, column. Row 4 finds its match in the second column, because of indexing I loose I set of data, the total row values should add up the values in column "B" Rows 4,5,6 etc each loose an additional column can u please help
Solved by K. S. in 24 mins
I would like to assign numbers from 1 column to names in another column and have them transfer to each worksheet
Solved by C. J. in 20 mins
Tough one (atleast for me). I am trying to group similar data in Excel. Below is a picture of what I am looking at and an explanation of what I am trying to do: The Value's across the top are the values for each zone. The letters down the left side are different variables for each zone. Some variables go that specific zone and some do not. For instance "A" goes to All of the zones as does "C". "B" however only goes to zones 1, 1A, and 2. I am needing for Excel to split these and list which "variables" (Column A) and final value totals for each different group of variables. So "A and B" would be a total of 29,483 as they go into all of the zones, and then it would also list "A,B,C" and a total of 25,651 since that only goes into Zone 1, 1A, and 2. I am needing those listed together in a easy to view table.
Solved by F. F. in 19 mins
I just received help on an excel file where the person I worked with helped stack Name, Address, City, State Zip. It worked online but when saved to my excel, all are on one line and not stacked. Could it be I have an old excel program? I'll upload my file with Column H being the one someone at Chat helped generate.
Solved by T. H. in 12 mins
In the Shop loading sheet, I lookup the calendar sheet and where it finds a match ( Q???? numbers) , I want the formals to lookup the count down sheet and match the respective hours, but I only want the. when the formula finds a match. When it finds a match I want it to always start in the first match column and thereafter index.
Solved by Z. F. in 12 mins
I have two columns of dates, and I need to apply a conditional formatting rule so that; If a date in Column B falls within 0-3 months of the date in Column A (same row), it highlights Green If a date in Column B falls within 3-6 months of the date in Column A (same row), it highlights Yellow If a date in Column B falls within 6-12 months of the date in Column A (same row), it highlights Red
Solved by X. S. in 25 mins
I am trying to find the correct formula to total column E for a specific person on column I
Solved by K. L. in 19 mins
Ok, I need to automatically sort data range A5:E12 based on the values in column E in excel.
Solved by F. F. in 29 mins
Formulas and vba programming. if I have 2 drug list columns (A and B). If column A "contains" the word from Column B then Keep it, if not....just blank or delete it. or example.if column " b" contains the drug actemra but in column "a" there is Actemra ++pfa then it's not picking up. I want to keep that drug. I want those drugs to be picked up to. then i have to automate it. =SUMPRODUCT(--ISNUMBER(SEARCH(B:B,A3)))>0 =INDEX(C2:C10,IF(SUMPRODUCT(ISNUMBER(SEARCH(B2:B155,A2))*ROW($2:$10))<>0,SUMPRODUCT(ISNUMBER(SEARCH(B2:B155,A2))*ROW($2:$10)),NA()))
Solved by S. J. in 20 mins
I have 2 drug list column A and B in Scan.xlsx. If column "A contains" the word from Column B then keep it if not delete. For example from the list, if column "b" contains the drug Acetemra but in column "A" the text reads Acetemra pfa then I want it to be picked up.
Solved by I. D. in 18 mins