I used to teach lunch and learns on it - basic idea is to use "record macro" to record your steps, then go into the code editor

and add in anything that is not "by rote" repetition.

ah. no. maybe i stated my need incorrectly.

what do you need the macro to do?

i suspect the function i need exists. i simply dont know what it might be called so that i could find it and use it

she's delegating Binary

i have a list. i want to put X's in the column next to the list. then i want to reduce the list to the x'd rows

i think that exists.

Hmmms - the Xs are in a column on a spreadsheet that is serving as an Excel database?

not a database. no. it's a report. the rows/report are populated by another tool. but i come along, and want to check the rows in which

i'm interested

and then on another sheet (if that's easier) i reduce the report to only the marked rows.

so - if i have a report of 10 rows plus the column header, and i mark 4 of them

hmm - I turned this up... something like this? www.freevbcode.com/ShowC...

i can go and generate a function(?) and reduce to 4 rows

Think it would be a loop to eliminate rows that don't have X's - or copy the ones that do... but I'll dig around

that might do it. am not sure if " take all the unique values" means that it takes non-nulls, or each check must be unique

yes - your last comment about eliminating not x'd or copying x'd is exactly what i mean

That bit of code is just a 'sorta like it" example, methinks.

/me nods. as i look at it, yes, i think that is sorta like it. *grin*

nods ok I'm in a meeting but might be able to poke Excel into action and try some mods later, if you don't beat me to it

ah - LOOKUP("X",A1:A500,B1:B500)

*grin*

that might be it, no

?

LOOKUP functions are used to index into data in a database usually... goes to see...

yes, that function is used to find a matching value in one dimension of an array, and return the matching value in the next dimension

not quite what you're lookin for

ah

okay. i will keep looking too. ty! i'll stop interrupting your meeting now.

lol - someone else is talking and I've already seen their charts