Hi,
Oooops - sorry my mistake. My version is actually 2003 - I was confused as the original file posted by SirBJ was saved as a xl2007 file.
Is it still possible to complete this command in 2003 or am I going to have to try moving into the 21st century and up grade my Excel?!!
cheers...
Hi oldchippy,
Thanks for your post - everything makes perfect sense and works well right up until I have to find the 'Formulas' tab'. I don't have this tab in my old version of Excel (2007). I quick check on the ol' interweb shows me that the tab is there in newer versions.
Do you know how...
@oldchippy
Hi - I appear to have fallen at the first hurdle: I've attempted edit the matrix data but cannot see a formulas pull-down menu.
What I did do that got me halfway there was to click on the little black triangle just in the top right hand corner of the toolbars (next to the fx...
@oldchippy
Thanks for the post - I'll give it a go and report back.
I've a couple of additional 'nice to haves' with this type of data transformations, but will save those for when I've worked through and familiarised myself with your and SirJB7's solutions.
Thanks again,
Regards,
Mark
Hi SirJB7,
Once again, thanks for your super quick response!
The file works a treat - would it be possible to have the grid in a slightly different orientation: 12 cells across and 8 rows down??
Sorry if is this classed as pushing my luck too much ;0)
Seriously though - thanks for all...
Hi,
My previous two posts were answered successfully within minutes :o) so I thought I'd push my luck and throw another question out there.
Being a scientist a lot of the data that I have to analyse comes back in the form of multiple Excel 8 x 12 cell grids. There are 8 rows (A - H) and...
Hi,
Would someone be able to tell me if it's possible to search previous posts contained within the Chandoo forum?
In this way I can avoid repeating a question that has been asked [multiple times] before.
Thanks for an excellent, amiable and well run site,
Regards,
Mark (Austinma)
Hi,
My name is Mark and I've been a user of Excel for more years than I care to remember. Most of my work with Excel relates to analysis of large scientfic data sets. I'd say I was a proficient user but am always looking to improve. Looking at the various posts and users on this site I'm...
Hi Excel Ninjas
Straight off the back of my inaugural post yesterday I thought I'd come back with another question....
I have two sets of data pertaining to the same unique identifiers (names).
For example First Data set 1
C1 C2
Mark Red
John Yellow
Mike Green
Steve Blue
and Data...
Hi SirJB7,
Apologies for replicating posts - will take time to familiarise myself with forum etiquette.
Question asked and answered in the space of a couple of minutes.
Superb.
Thanks to all,
Regards,
Austinma
Hi
I can easily define the following formula by typing the text and dragging the cursor over the range of cells that I want to select:
=SUM(A1:A20)
If I wanted to fix the range to give the following formula:
=SUM($A$1:$A$20)
Then I would have do to manually type the '$' signs on either...