Excel 2004 and Find All.

Jump to First Reply
mike fishcakemike fishcake
Posted:
in Mac Software edited January 2014
Hi,



Been using my new Mac Mini for a while now - getting used to it and everything. However, one thing that's stopping me from using it regularly is the lack of a "find all" function in MS Excel 2004. I've checked the newsgroups, and there's a post from someone saying that there is no "find all" function is office 2004, which seems completely daft to me (and annoying, because I use it a lot).



So, does anyone know of any setting that I'm missing, or if not an official/unofficial patch to add the functionality, otherwise i'm going to have to carry on using my WinXP PC for Excel work.



Cheers!

Comments

  • Reply 1 of 8
    mike fishcakemike fishcake Posts: 44member
    Thanks for the hint, but it's not really what I wanted. Basically, in Word 2003 on windows, in the search box, there's an option to find next, replace, or find all. when you click find all, it brings up a list in the find window of the cells that contain the word you searched for. Office 2004 on the Mac doesn't, for some bizarre reason that I don't understand
     0Likes 0Dislikes 0Informatives
  • Reply 2 of 8
    artanisartanis Posts: 156member
    Maybe they thought it is not necessary anymore. The thing is that with the "replace all" function u don't really need anymore a "find all", in my opinion.



    U could try the freeware neooffice to use "find all" in the spreadsheets.
     0Likes 0Dislikes 0Informatives
  • Reply 3 of 8
    toweltowel Posts: 1,479member
    You could do an AutoFilter for Contains "something". That would isolate and display all the ocurrances of that word in a given column. Not exactly what you wanted, but it might help.



    Not knowing what sort of data you're crunching, I wonder if your reliance on Find suggests that you might benefit from a different way of organizing your data to begin with. Or a different program for manipulating it. You might find database queries or greps a more efficient way of finding groups of data.
     0Likes 0Dislikes 0Informatives
  • Reply 4 of 8
    mike fishcakemike fishcake Posts: 44member
    Quote:

    Originally posted by Towel

    You could do an AutoFilter for Contains "something". That would isolate and display all the ocurrances of that word in a given column. Not exactly what you wanted, but it might help.









    I'll give that a try and see if its a realistic workaround. thanks!



    Quote:

    Not knowing what sort of data you're crunching, I wonder if your reliance on Find suggests that you might benefit from a different way of organizing your data to begin with. Or a different program for manipulating it. You might find database queries or greps a more efficient way of finding groups of data.



    It's a daily downloaded spreadsheet full of prices for thousands of PC components from suppliers, so it's not really something i can manipulate. I'll give your first suggestion a try though.



    I really wonder why it was left out. Just bizarre :-S
     0Likes 0Dislikes 0Informatives
  • Reply 5 of 8
    mike fishcakemike fishcake Posts: 44member
    Quote:

    Originally posted by Artanis

    Maybe they thought it is not necessary anymore. The thing is that with the "replace all" function u don't really need anymore a "find all", in my opinion.



    U could try the freeware neooffice to use "find all" in the spreadsheets.



    I tried NeoOffice and it is better, but still not exactly the function I'm looking for. I'll have a fiddle around with it and see if I can find what I'm looking for.



    Basically, if you click here:



    http://www.teamfishcake.co.uk/mikes_...ll-windows.gif



    it gives a screenshot of what I use in Windows. Sometimes I need to search the entire spreadsheet to find parts from a specific manufacturer, or hard drives of a certain size for example, and Windows Excel puts the cells in a list, as you can see, which gives me an opportunity to sort by alphabetical order and so on. However, Mac Excel doesn't give the option at all, and as far as I can gather now at least, NeoOffice just highlights the cells in the spreadsheet, which does mean I need to scroll through the entire spreadsheet.



    It's not a matter of life or death, it's just something that would be nice to be able to do. If I can't do it, it's not really a huge problem, just a minor inconvenience.



    Thanks to all of you for helping me out with this anyway
     0Likes 0Dislikes 0Informatives
  • Reply 6 of 8
    mike fishcakemike fishcake Posts: 44member
    Quote:

    Originally posted by tonton

    Ah. Simple. Use a formula to test for occurrences of the string then sort by the result.



    Just add a column of this formula:



    =IF(ISERROR(SEARCH("eagate",BX,1)),0,1)



    Where Column B is the description column and "X" is the same row your formula is in.



    It gets a little more complex if you want to search several columns, like column B or G, but it can be done.



    Then you sort by the column where you've filled in this formula, and all the rows with the text "eagate" will all be together on the top of your list.



    Thanks, I'll give it a go!
     0Likes 0Dislikes 0Informatives
Sign In or Register to comment.