Get instant live Excel expert help with COLUMNS Function

I need to separate out the city and state in 2 columns

Hi! Let's say I have 5 columns. The columns are not necessarily the same "height". I need to be able to combine 5 random cells, one from each colum. It'd be great to keep a record of each individual iteration for later inspection i.e. saving every output I get. Cheers!

I need to total 2 columns and then multiply the results

Your coworker comes to you because he cannot figure out the error in the following formula: =sum(A5:G5)*H3 Columns A through G contain values which he needs to sum together and then multiple by a constant value in cell "H3". He used the fill function to apply the same formula to all the rows below with positive integer values in each cell. However, the calculation in the formula produces a value of "0". How can your coworker correct the error in his formula?

ON THE TAB "monthly income received" the cells on row 11, should calculate all amounts from tab "residents" in columns "amount os" from each month separately. the dates are in "next pay date" across the sheet.

Hi! This seems to be a VBA macro issue. Let's say I have 5 columns. The columns are not necessarily the same "height". I need to be able to combine 5 random cells, one from each colum. It'd be great to keep a record of each individual iteration for later inspection i.e. saving every output I get. Cheers!

I need to find out if/where is the entry inSPtitlequotadef sheet by using the title and quotanumber columns in the quotaandvariable sheet

Hi! This seems to be a macro issue. Let's say I have 5 columns. The columns are not necessarily the same "height". I need to be able to combine 5 random cells, one from each colum. It'd be great to keep a record of each individual iteration for later inspection i.e. saving every output I get. Cheers!

i need to add 'amount os' columns in 'residents' tab adding together and porting to 'monthly income' tab. for each month individually. Oct, Nov etc. the 'amount os' rolls the previous 'amount os' over if it falls within the same month. we cannot add cells K3 TO Q3 as it gives a false figure, the total should be for these two cells should be £5440, so the previous months 'amount os' needs to be deducted from the calculation q3-k3 gives the correct amount for that row. we will not get more than two amount os on any row as the payments are 28 days apart. the cells for 'amount os' for Nov-18 are as follows K3,K9,K11,Q2,Q3,Q4,Q6,Q7,Q9,W5,W8

I am trying to compare times and have converted the same time in two different columns. Why does 7:59:21 AM return 43419.33 and 0.3329?