Forum Discussion

Copper Contributor

Jun 12, 2020

Search and results display

Hello This is a very newbie question, I'm afraid, and I apologise for that. I've no experience of using Excel other than reading the odd document in .xls format sent to me from time to time. Ho...

excel

peteryac60

Iron Contributor

Jun 12, 2020

LittleValley1

if you attach the spreadsheet we can have a look.

thanks

peter

LittleValley1

Copper Contributor

Jun 26, 2020

peteryac60

Sorry for the delay in replying; I hadn't realised that there'd been a responseto my cri-de-coeur (no email alert, nor a spellchecker...)

Anyway, the file is attached, as suggested.

Thanks

Glyn

Copy of BAL_Database_2019.xlsx180 KB

peteryac60
Iron Contributor
Jun 26, 2020
LittleValley1
Hi Glyn,

The solution suggested by SergeiBaklan will definitely work but as you are an excel newbie I would guess that you do not understand it.
However, if I understand your problem correctly a more simple solution is look at the box at the top left corner and that will tell you the CURRENT cell.
In the example below, I searched for Mozart and the first occurence was inn Cell E107. Look at the box in the top left (highlighted in yellow) and that will tell you the current cell where Mozart is to be found. Hope that helps you.

Peter
- LittleValley1
  Copper Contributor
  Jun 28, 2020
  peteryac60
  
  Thank you Peter for drawing my attention to what was under my nose! It certainly works well enough for my purposes.
  Glyn