cross

Can anyone explain how this is done in Excel please, I dont have a pic but, say you had a number of rows and in each of the end cells, you want to add multiple comments seperate from each other, (not insert comment) so when you look at the spread sheet, the end cells have muliple boxes in them...

Hi All, i really hope someone can help me with this as it means i can stop wasting 3 hours a night doing it manually. I have 3 CSV files that are price files and have fields such as Part Number and Quantity. I have 1 CSV file that is my upload file with the same fields but showing data from the...

Hey all, This one will be a tough one to explain... I essentially have 3 columns of data and 40000+ rows of it. Column A measures seconds from time 0 to say 10. Column B is a series of values creating on a graph wavelets from a source detected by receiver one and Column C is the same series of...

I have three worksheets I'm trying to work from. We will call them Worksheet 1, 2, and 3. I am trying to fill a column in worksheet 1, we will call it "Column B" for accuracy purposes. In order to fill this column, I would like to cross reference the data from Worksheets 2 and 3, and if a...

I have 2 columns of data, each with variable length: C1 C2 a x b y c z d I need to create a cross-product of these text fields that would provide the following: ax ay az bx by bz cx cy cz dx dy dz Is there a formula in Excel or a VBA macro that could produce this? Thanks. MD