I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel:
I have the current sheet of data:
The formula and the data links to this test sheet of data:
Now I have done about 90% of the work (I hope), seen as my...
change rows to columns
column appearance change
formula = concatenate
index & match
transpose & index
transpose & match
transpose column to row
vba & add
vba & excel & forms
Hi all, I'm after some more help with my spreadsheet - this time with finding some of the oldest outstanding of particular items
The spreadsheet below is an exert from the Master. I need to show the oldest date of items yet to be completed which is displayed in a 'metrics' table on another...
Perhaps a very simple one - I'm trying to give an average of time taken for a team to process a quote to a customer. my table has three columns:
start date, end date and days taken (to process quotes) in another column I would like to calculate the running total of days taken to...