Get instant live Excel expert help with COLUMNS Function

Hi! This seems to be a macro issue. Let's say I have 6 columns with varying "height" in a sheet, each cells' contents is anything between a single word and two sentences. In another sheet, I need to be able to combine 6 random cells, one from each colum. I need to be able to re-randomize each cell separately, much like rolling the separate sections of a combination lock. There should be a way to save any given combination of 6 cells on either the same worksheet or in a third one. Cheers!

Hi! I am not getting excel to sum. Not on the bottom toolbar or with formulas. (I copied info from my bank statement, pasted value into excel. It brought in a $.) Troubleshooting steps I have already taken: -Formatted the cells to number, accounting, currency, etc -Text to columns (general) -Text to columns to remove the $, then formatting as number -Automatic calculations is on -right clicking the bottom tool bar, sum is selected -& opening & closing the workbook (it does not give me the option to "enable", so I think that one is ok). What should I check next, please & thank you!

I have three sheets with dates and relevant data 'amounts'. I need to remove duplicate dates on each of the sheet before 'sumif' the 'amounts' w.r.t. to each date on each of the sheet. Then I need to bring the new dates list from all three sheets to one master date sheet - remove duplicate dates again, sort them ascending and then look up for the 'amounts' for each of the three sheets to be added in three difference columns of the master date sheet

I need to select the last row data from columns A thru R, then copy and paste formulas only to the next row, then select the new data and copy and paste values only to another sheet in the same workbook using macros

suppose I have three columns...country,continent,population...how to get the maximum of each continent

I have two columns. sales_date, customerId . I want how many times each customer placed order.

I want to compare 2 columns with this formula = IF (ISERROR (MATCH (A1, $ C $ 1: $ C $ 5.0)), "", A1)

i need a formula to add columns 2-20 in excel doc

can you help me with a problem? I want to add to 2 columns, S51 to S55 and S57 to S60). How do I do It in Excel, thanks

Col A is a customer name. Col B thru L is quantity they bought. There is also a pivot table filter of year (total 3 years) I would like a way of showing, in all three years combined, how many customers bought 1 item, 2 items, 3 items, etc, by looking at the number of columns that have a value. So for example, the first 3 customers bought 1 item each, the fourth bought 2 items. Please display graphically.