Search results

It has worked perfectly and does exactly what I needed - thank you

Thank you I will try the above. Is this called a nested IF function?

Hello I have a worksheet that I want to add a formula to which will project dates based on a wording in a particular column. So I have =IF(B2="One week",A2+7) or =IF(B2="Two weeks",A2+14) or if B2="One Month" then =EDATE(A2,1) or if B2="Three Months" then =EDATE(A2,3) How can I include all...

Thank you AlanSidman, I am in the process of creating a spreadsheet to show what I am trying to achieve... I will repost later today...

Hello I have a project where I receive sheets from many different departments and need to be able to split each sheet up by a category and then copy that entire row entry across to a master sheet that adds in effect collates the information for that category.... I have found some VBA online, but...

When I downloaded and opened it it showed the correct count (51) but when I then enable editing (as it displays protected view, that number changes to 1 (1)... Not sure what I have done wrong here????

Thank you I will take a look now :-)

Hi - I posted yesterday regarding named ranges and was kindly informed of index or offset to make a named range dynamic. However I cant seem to grasp how to make these work within other functions. I have attached a sheet and am trying to create a dynamic range (that will adjust when rows are...

I can’t seem to make these do what I need them to do - I know it’s me!! I have attached a sheet and wonder if someone can show me what I’m doing wrong... I need a range that changes as rows are added (index or offset) and a return count of unique numbers in the column. I did this when I had a...

Thanks you so much - I will have a look at the links

Hello I had successfully created a 'dashboard' using a datasheet formatted as a table, but when sharing the workbook in the review tab, it says that sharing does not support a table and to convert to named ranges. I have now converted the table named ranges (which allows the sharing of the...

Didn I know! Funny thing is now I put an additional row into the worksheet it is working as I set it up - thank you !

thanks i will try this and report back :-)

Hi I have one horizontal countif ... =COUNTIF(D6:Z6,"*") bringing back a count and I want to capture the resulting cell return that is greater than 0 in a vertical countif - I have used =COUNTIF(C6:C96,">0") but it keeps coming back with 0. This does not seem to want to work on Excel 2016...

Thank you Hui that’s worked perfectly! And to AliGW too !

Hello I tried it but it only brings back no even when there is something in one of the cells ? What should I be putting in the criterion part? =IF(COUNTIF(A1:T1,criterion)>0,”Yes”,”No”)

Thank you I will try this out

I want to look across a row of cells and if any one of them has some data in to cell it returns a yes or no return .. . I am using counting to count how many cells have something in, but I want another return that doesn’t count ... many thanks

Hi Is there an easy way to convert a matrix type table into a list in Excel? I have uploaded an example worksheet. The yellow shaded section is the matrix and the blue shaded section is the list I would like to achieve. I think it may be VBA if anything??? many thanks for any help.

Narayan. Will this work if some months have zero data? It doesn't seem to allow expon. trend lines when there is zero in my data :-/

Narayan. Wow that looks great. I have 22 others to do, but that is exactly what I need to show. Thank you

Hi Vletm - I don't think I am explaining myself too well. I only want one arrow based on a 12 month period of data, not one for every month.. Thank you for your help though...

Hello and thanks for your reply :-) I have added my file now. Would you be able to have a look at what I've done? I wanted to use arrows to indicate the trend for rolling 12 months i.e up, down or the same...

Hello all I have some data across 12 months Jan to Dec. I have created a short trend (month on month) using IF and wingdings characters to show 'up' 'down' or 'no change'. I would have used sparklines, but they dont display a trend line :-( BUT I need to show the longer term trend over the...

Hello clever Excellers.. I have attached a file that has two pages one being the main table and the other being some data I want to use to populate the main table. I had created a valid list on the main sheet that used the months from the other data table to then fill in two cells one showing...