• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    96 Cell Grid Transformation with label

    Bingo!!!!!! Clearly nothing wrong with your memory!! Thanks for persevering. Best wishes, Austinma (Mark)
  2. A

    96 Cell Grid Transformation with label

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

    96 Cell Grid Transformation with label

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

    96 Cell Grid Transformation with label

    @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...
  5. A

    96 Cell Grid Transformation with label

    @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
  6. A

    96 Cell Grid Transformation with label

    Hi SirJB7, Perfect - off to work tomorrow to spread the word! Cheers Austinma
  7. A

    96 Cell Grid Transformation with label

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

    96 Cell Grid Transformation with label

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

    How to search previous Questions listed on Chandoo's forum

    Yet another good reply - cheers Hui. Thanks, Mark
  10. A

    How to search previous Questions listed on Chandoo's forum

    Thanks to you both for your helpful comments. Time to put the kettle me'thinks...... :o)
  11. A

    How to search previous Questions listed on Chandoo's forum

    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)
  12. A

    Comparing data sets with common and unique identifiers

    Excel Ninjas Works like a charm. Thanks for your collective efforts!! Regards, Austinma (Mark)
  13. A

    Comparing data sets with common and unique identifiers

    Hi Luke M, Thanks for your very quick reply. I'll give it a go....... and report back what happens Cheers Austinma
  14. A

    Hello .. Introduce yourself

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

    Comparing data sets with common and unique identifiers

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

    Shortcut for Fixing cells or Ranges with the $ symbol?

    Many thanks to all posters - you've all been a great help. Regards Austinma
  17. A

    Shortcut for Fixing cells or Ranges with the $ symbol?

    Great tip - F4 might well be my new favourite key! Makes me wonder what the other Fx keys might do..... :0)
  18. A

    Shortcut for Fixing cells or Ranges with the $ symbol?

    Been after this shortcut for ages - feels good to finally scratch the itch. Go Excel Ninjas indeed!!
  19. A

    Shortcut for Fixing cells or Ranges with the $ symbol?

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

    Shortcut for Fixing cells or Ranges with the $ symbol?

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