Search results for query: *

So sorry, suffering from alzheimer's.

Seems like a simple need, tried searching for a solution! Have list of names in two columns, column 1 and column 2. Need to generate 2 new columns that assigns all names in column 2 to each name in column 1. Column 1 = A, B, C Column 2 = X, Y Creates the following Column 3 = A,A,B,B,C,C...

Thanks John, I searched using Excel filters, rather than dynamic data validation. thanks for taking your time to point me to the link, appreciated.

Thanks to Skip and Glenn, I have not yet had a chance to investigate your suggestions. hope to get at it later today. Cheers, John

Can't find a solution for this in prior postings, however: Col "A" has list of items that need to be associated with two attributes in Col "B" and Col "C" Using data validation for Col "B", no problem. However need to make the validation list dynamic in Col "C" based on the selection made in...

Thanks Skip, Just started to play around with that function and it looks as though I have it apart from a blank month, if I set blank to zero it works. Average(Offset(J2,0,Max(Count(J2:BM2)-12,0),1,12)) Appears to do what I need. J2 is first month record, BM2 is latest possible month...

Multiple years of Monthly columns, need to get rolling 12 months of data available. The Rows don't all have data to latest month. Therefore how do I sum the 12 months up to and including the latest month available. Can assume once latest month found add to it the prior 11 months even if they...

Skip, Saved my afternoon, Many thanks JR

Trying to combine data and expand rows, example of two work sheets and the desired result. Worksheet 1 Job Role Step Coordinator Update Pricing Buyer Update Pricing Worksheet 2 Step Course Update Pricing ME52N Update Pricing ME53N Result - Worksheet 3 Job Role Step...

Thanks for the quick response, I will give it a go, not sure about becoming an expert though!

I have a large volume of excel files stored in a folder, each file name relates to a project, I have a master list of project names. How can I copy the file names from the directory into an excel file such that I can then validate the files names against the project master list in excel...