Search results

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...

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...

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...

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...

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...

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.

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...

Hello. I thought I had been given the answer to my question, but looking back I didnt (my fault for not explaining) and now I need this information to work again. I have attached a sheet with an example of my data and then what I need it to do. I think its an IF function. Basically trying to...

Can someone help please? I am trying to get the correct formula to compare a set of months by another set of months. I have tried SUM and IF but must be doing something wrong as it wont work :-( I have attached an Excel sheet with some dummy data to demonstrate). I dont use VBA but want to...

Hello all I am trying to workout how to select lines of data where the time period covers between two time periods 2300hrs and 0600hrs. I have 4 columns with many lines of data but have possted 2 example lines as follows:- both include part of the period I want to capture! A=01/01/2012...