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

I am looking to show the value from a different cell if Yes is shown in a different cell in a different column. If "Column H" of "Tab A" is shown as "Yes", then I want to add the value of "Column B" of "Tab A" into "Column A" of "Tab B". I am then looking to do a further action relating to this. If "Column A" of "Tab B" is populated by the above, I then want to show the values from "Column E" and "Column F" from "Tab A" in "Column B" and "Column C" of "Tab B". Can you help me please?
Solved by E. E. in 19 mins
Why does the percentage on D7 of 23.35% not equal the average percentage of the percentages in Column D 3-5 as this equals 22.17%? Is there a calculation that will take me back to the 23.35%? Thanks
Solved by I. J. in 11 mins
I am trying to take a master list of employee information and break it down in to other spread sheets. I need to break it down based on information in one of two columns, by department - column F and by job title column E. I have tried numerous macros and looking up coding online with not luck. I keep getting errors or it simply doesn't do anything. Should the cell in column F say ATS or ATS/CSS I need that row to be automatically updated in the ATS sheet. Should it say ATS/CSS or CSS I need that row to be updated in the CSS sheet. For column E I need RSS to auto update the RSS sheet, RN - RN sheet, LPN - LPN sheet, and so on. I would like to make a code that will allow me to update the master sheet and automatically update the subsheets. Due to the nature of this information I had to remove most of the document but left enough information for assistance.
Solved by D. E. in 27 mins
After i had choose "AB12/AB08 WHITE HIGH VOLTAGE" in the column I, there are only left four row of data. I want to sort the data by date in Column O. (either new to old, or old to new). However, come out with "Operation require the merged cells to be identically size". I had do some research online but there are only suitable for fixed data(no add data anymore.) Since I need to add more data in the lower row, I need to find a easier ways to settle this. Are there any solution? Thanks for your help
Solved by Z. F. in 17 mins
The identical value in the data is seemingly arbitrarily split into two columns in the pivot tables. On the attached workbook, the red worksheets contain the data; the other colours are the pivot tables. As an example, I checked each cell containing the value "All" using the "=ISNUMBER" function. All returns were "FALSE", which if I understand correctly means that the value is text. This is as it should be. The purple worksheet "Lecturer totals T1" contains two columns for "All", "Lecturer totals 01-17" contains two columns each for "BaL" and "HLS" "Lecturer totals T2 & 3" contains double columns for all these three values. The same is true for the equivalent green "Faculty totals" and orange "Student totals" worksheets. How can I ensure that the pivot tables only contain one column for each of these values?
Solved by E. D. in 13 mins
howdy! I am attempting to collate data from multiple cells in the "related_asset_id" colume into the same cell in "new_related_id" column , if and only if the cells all have the same "title"
Solved by S. E. in 23 mins
At work we have a main spreadsheet of students. Some of the columns are merged down 5 rows while the other columns are single cells. Need to find a way to filter or list on more than one column. For example, all cells in column E which include "Pending" but also sorts the list of Schools in Column D into alphabetical order
Solved by G. L. in 14 mins
In column c I have one price and in column d I have another. If column D is greater than 0 then I want to use that price; however, if column D is equal to 0 I want to use the price in column C. I want a formula for column E that will choose the appropriate price from the columns to insert the price.
Solved by X. S. in 27 mins
I have a spreadsheet that computes a net golf score. The computation differs if a golfer plays from one set of tees (e.g., white) versus another set of tees (gold). Also, since not all golfer play each week, I want a blank space (v. a zero) in the column where the computation occurs. The formula I am trying to use is --
Solved by S. F. in 24 mins
I have a worksheet with dates in column D and various reason codes in culumn U. I need to report the number of occurrences if each reason by date
Solved by V. E. in 23 mins