eliminated the follows after the key  number
29118287d--1-_to_add_after_key_clea.xlsm

Cannot remove filter in Excel 2010. The option it is grayed out. See attached file.
Cannot-remove-filter-in-Excel-2010.pdf

key number is 44
then when it repeat  after the row 48

need to delete the follows numbers

with an button
Eliminated_repeat_data.xlsm

Excel has data in columns A and B. Either columns can have blank and duplicates.

What is the fastest code that can find the number of unique matches between them?

Hi
I am looking for an excel function or combination of functions to find out unique number of values by names. Also, i need to add a criteria in the function. Ie where some other field  only with blank cells.

Hope you understand. I can upload a file if you want to.

Thank you
A
aa.xlsx

Hello,

I have the following procedure which allows me to replace values based on config sheet.
I would like to add the procedure to my personal.xlsb with the following requirements:

1-Add msgbox (yes, no) which says “Have you already created config sheet?” vbCtrl
“Sheet Name: Config-Replacement” vbCtrl
“Column A values to replace” vbCtrl
“Column B revised values” vbCtrl
“Column C reference column in which are located values to replace” vbCtrl
“Column D sheet name in which replacement procedure should be applied" vbCtrl
“Column E flag value: 1 for exact values” vbCtrl

2-If vbno is activated the config sheet reported in my example should be created with format and
headers. Else Run the replacement procedure
3-If vbno is activated and config sheet already exist. Exit sub and display msgbox which says “Config sheet already exist."


If you have questions, please contact me.
Replace-values-based-on-config-shee.xlsm

In excel if you have long text in a cell that doesn't fit, it can overflow into the adjacent cell, as long as the adjacent cell is empty. I wonder if I could get the same behavior when I have a formula in the adjacent cell returning "". Unfortunately by default in this case, the text doesn't overflow.

I'm using Excel 2010

hello, I'm trying to paste a value with "Match Destination formatting" but this option is not available or gray.  any idea please?

Hi

How can i count number of dates greater than a given date in excel, using excel function(countif)?

Thank you

i want to know the api of a software
how to get it
in what ways we can find the same?

Looking for a Macro in Excel. I have a workbook with around 80,000 address's in the state of Iowa. I would like to be able to input a zip-code into the macro and the quantity copied to sheet 2. Preferably the address's pulled based on that quantity would be randomized. I've attached a demo list.

In a perfect world I'd be able to enter up to 3 Zip-Codes and randomly pull the requested quantity. This is a list I'd refer to often as this client has blood-drives at different locations across the state. They supply an internal list, after I dedup and remove the bad address's we often need a few hundred more address's in that drives zip-code.

Thanks in advance!
Excel-Demo-List.xls

We have a file that was updated on the server.  It's an Excel spreadsheet.  The file date shows 9/18/18.  If I open the file on the server or at most users desks, it shows the updates recently done (we have the last user who modified the file put in a footer with their initials and the date they modified the file (9/13/18).
There are 2 users that, when they open the file in Excel (local copy), it shows an older version of the file (the initials inside the file and the date are older).  The date on the file from their Windows Explorer shows as 9/18/18 = correct.
I can't find any way for them to open the correct file.  It shows as the same file but once open - its the older version.

All the users are using Office 365 = currently Excel 2016
All users are running Windows 10
I clear caching folders - ones I could find on the users' local computer
I ran an Office online repair as opposed to the quick repair
I ran Windows updates - there were updates but non fixed the issue

I'm stuck

Some time back we placed a question on how to read data from an internet page and save the specific content to an excel workbook (maybe it was a VBA).  We tried to search it in EE but can't find it.  So hope we can get the answer again.  We have certain web pages that we need get a specific data and save it's contents to an Excel.  For example, a user logs into a specific web page and register his work on it.  If a non-user views it, it always present the last user who saved his entry.  We want to read that user name and save it in the excel workbook.  The user name will always be in the specific location.  What is the best and automated manner in pulling data from a website into Excel?