You could do a COUNTIFS and see if there's at least one data point.
While we could certainly write some code, you could use this add-in to merge the data? Let's you pick your files, worksheet(s), and range you want copied.
Should be doable, but some more info would be helpful for building the exact code. Are you wanting to send a basic message to each user, an image from body of workbook, or an attachment? Is it just the two columns of data we need to work with?
One way I'd do it is to copy the list of emails to a new blank column, Remove Duplicates. Then cycle through that unique list and use it to filter for emails back in your original data. Depending on what we do next, we either create an attachment to send, or copy and image.
The labels in a PivotTable, including dates, are all displayed as Text. So, when trying to match up against the numerical date in A1, it's failing. You might have success by changing the "$A$1" argument to this
TEXT($A$1, "dd/mm/yyyy h:mm")
While you could do this, it would be far easier to just Insert - Symbol, and use those in an IF statement.
Look under the Segoe UI Symbol list.
Between dynamic and table, I'd say the table will generally always win (assuming you don't need XL2003 and older compliancy). Beyond that, your next consideration is whether the data should be in a database like Access vs. Excel. If you start handling over 100k of rows, XL will start to struggle to keep up.
I'd suggest using the table. It's more "native" should will be faster than first having to do a formula calculation (even a simpel one) to define the table range. Also, using the strcutural references it'll be easier later to determine what all the formulas are doing (assuming good field names).
Digger deeper, why do you want the cell address? Reason I ask, many times people do this and then feed the address into INDIRECT, when it's generally easier to get the data directly.
But, assuming value only appears once
=ADDRESS(SUMPRODUCT((TableRange="SearchValue")*ROW(TableRange)), SUMPRODUCT((TableRange="SearchValue")*COLUMN(TableRange)))
Wow, that one was buried deep. Turns out the names were hidden from the file manager. Not sure how, but they're there. If you run this short script, you'll then be able to see the names and delete them.
Here's I tool put together compiling various password tools. Workbookand Worksheet protection are the easiest to remove.
https://chandoo.org/forum/threads/remove-password.23208/
Just sheet protection: http://www.mcgimpsey.com/excel/removepwords.html
You need a way to tell the VBA that you're not ending the string, so we use double quotation marks to indicate that "yes, I want a quotation mark here". I also went through and optimized things a little bit
It looks like column A is your label, and B:D are your inputs. Col E (to check your math) would be simply
=SUM(B2:D2)
In F2
=(12*B2+3*C2)/100
In G2
=(100*B2+30*C2+5*D2)/100
My guess is that you have a sheet name with a space somewhere in the name. In which case, you need to make sure you're including single quotation marks around the sheet name. Try something like this
Change the 2nd argument depending on when your week begins, but would be something like
=WEEKNUM(E2, 1)
Other formulas:
=MONTH(E2)
=INT((MONTH(E2)-1)/3)+1
=YEAR(E2)
Try this. It'll automaitcally clear out old query before running, and it returns all matches and relvant info.
You want to use the EntireRow to get the range selected, not the Row property.
I'd suggest just putting a mark of some kind in a helper column (maybe an "X"?), and then use Data - Filter, and you can filter your sheet to only show those present, and print that out.
Looks like the attachment is missing?
