Recent content by Ellasheba

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 !