Looking at the dataset, the filter feature was helpful to show the list by
institution. eg, here's researchers with SFI listed as their primary
institution. the rank is in the second to last column.
[image: image.png]
___
stephen.
If I export it to a CSV file I'll just put in on my Linux machine and use
grep.
---
Frank C. Wimberly
140 Calle Ojo Feliz,
Santa Fe, NM 87505
505 670-9918
Santa Fe, NM
On Sat, Nov 26, 2022, 2:36 PM Gary Schiltz
wrote:
> Instead of digging into the guts of Excel with Visual Basic, I think
> it
Instead of digging into the guts of Excel with Visual Basic, I think
it would be about as easy (and maybe more fun) to import the
spreadsheet into a database that you could query. If I were to take a
first crack at it, I would first export the Excel file to a comma
separated values file (CSV file).
There's a bunch of functions that take a range of cells as input and
different outputs depending on use case (find, search, match, vlookup,
hlookup, etc)
Examples here: https://www.exceldemy.com/excel-search-for-text-in-range/
On Sat, Nov 26, 2022, 8:42 AM Frank Wimberly wrote:
> I used to kn
That sounds like an interesting spreadsheet. I'd be interested in that myself.
For something like that, the Find menu option would work, but you might have
better luck finding who you're interested in buying putting filters on the
column headers and using them to narrow down the rows to look at.
Thanks, Brent.
Stanford published a spreadsheet with about 200,000 researchers. Each row
contains name, institution name, country, etc. I want to be able to search
for the data about a given individual, the people associated with an
institution, etc.
I used to program macros in VBA but I only d
If you just want to find something, using the Find option from the menu will
work and it should give you the option of searching within the current sheet or
across all sheets in the workbook. If there are multiple results, it should pop
up a docked window at the bottom of the spreadsheet to show
I used to know Excel pretty well but that was decades ago. I want to find
a given string, say "Wimberly" in a large spreadsheet. How do I do that
simply? FIND function wants to provide the location within a larger string
of a substring. I want something like the Unix "grep' command.
--
Frank
