Microsoft Excel

134K

Solutions

38K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Experts,

Please help me with code. I have attached excel file. In that Column D has resource name, there if there name is repeating for more than 2 times shows some pop up or highlight the repeated.
Book1.xlsx
0
Fundamentals of JavaScript
LVL 12
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

eliminated the follows after the key  number
29118287d--1-_to_add_after_key_clea.xlsm
0
Hey everyone,

Took a look at the EE forums but can't seem to find a solution.

I have a user who is unable to load the Solver add-in in Excel.  The add-in is selected, but when going to Data > Analyze, the Solver button is not fully there.  To be specific, the question-mark/arrow symbol is there, but it doesn't say Solver.  When clicking on the button, nothing happens.

The user is on Windows 10 with Office O365 2016 v.2215.  Our company has gpo restrictions on loading add-ins, but I am able to load and use it on mine and a test machine w.o problem.

He receives a msg about macros not being able to load, as did I, but on the test machines I received a prompt to trust the add-in, whereas he does not.

I removed and re-added the add-in, ran a repair on Office, upgraded Office to our current version, and replaced the Solver.xlam file on the user machine, no change.

The one thing I did not try yet is a different Windows profile.

Thoughts?

Thanks,
0
Cannot remove filter in Excel 2010. The option it is grayed out. See attached file.
Cannot-remove-filter-in-Excel-2010.pdf
0
Every time I open Excel it also opens my

PERSONAL.XLSB

file.

What do you think is happening?

Thanks!

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

need to delete the follows numbers
a1.PNG
with an button
Eliminated_repeat_data.xlsm
0
I need to read  a number of comma delimited csv file from a specific folder and put each file into a worksheet with the name of the worksheet being the name of the csv file.  How do I do this using Excel VBA?
0
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?
0
I am sorting the status of a job as Loaded / Unloaded based on the text within the cell. What i need is to have a macro button installed which when pressed should read the cell value in  the status column and if it finds "Loaded" in column "S" then move the entire row to a different workbook (lets call it workbook2). Upon the transfer of the row of data it will delete from the current sheet. Workbook2 will have  two sheets for the sorted data - one for loaded and one for unloaded. An important feature of this code is that workbook2 already exists and therefore this macro will just need to open this notebook and save / close once the rows have been transferred.

My intent is to use this macro command button as an archive button to export the data from the current file to the next available row in  workbook2 (a pre-existing workbook).
1
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
0
C++ 11 Fundamentals
LVL 12
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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
0
Hi

I have been asked to build a solution that saves documents and messages emailed back and forth in Outlook into some sort
of repository that can then be accessed from anywhere. I am looking for suggestions on the best way to do this using Excel/Outlook/Access VBA code, ASP.net webforms  and SQL.

My initial thoughts were to automatically send a copy (CC) message of all Outlook emails to an email address set up specifically for this as a starting point
then either store the documents on the company cloud server or in an ASP.net folder or SQL database.

Thanks
1
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
0
Dear Experts

In excel I need to rearrange the contents of a cell using a formula ... Each cell has 3 bits of information

job, company, dates (i.e. CEO, Microsoft, 2015-2018)

These are all all separated by ", " (Comma space) & I need the result to read

company, job, dates (i.e. Microsoft, CEO, 2015-2018)

Can anyone help?
0
hello, I'm trying to paste a value with "Match Destination formatting" but this option is not available or gray.  any idea please?
0
Column A & B can contain over 500,000 values and changes over time.

What is the fastest code that will find all cells in column A with "Hello World" and put the corresponding value(s) from column B in an array without iterating through all the rows.

Example:
A.                      B
144.                  ddgh
24477.             355:+fd
Hello World     aaaa
1188.               &554&
ffhj
Hello.               xxccffee
Hello World     bbbb

In the above example it would put aaaa and bbbb in an array because "Hello World" is in column A for them both.
0
Hi

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

Thank you
0
Hi Experts,

Hoping someone can help me with a solution to automate a manual daily task
I need top download a file from a http (url - report server) site and save it to a folder at regular intervals ( hourly )

The manual process is as below
1) Go to the website/url using IE
2) Click on a drop-down item and select "Export to Excel"
3) A pop-up appears to Open or Save the .xlsx file
4) Click on Save button
5) Save  it to a folder location on my pc.

I cant use any 3rd party tools or software as I cant download it due to restrictions in my organisation.

Preferably excel/vba solution or if there is an inbuilt windows solution to capture and record actions above and then schedule it at regular intervals.

Thanks
0
i want to know the api of a software
how to get it
in what ways we can find the same?
0
Become a Certified Penetration Testing Engineer
LVL 12
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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
0
How can I get the following to give me a subtotal when filtered

=COUNTIF(A:A,"*")

This is on a column of text.
0
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
0
tally_duration.xlsxtally_duration.xlsxI have a raw data set that includes hourly pH values at multiple sites ("Sonde_Names") for two three-month periods: one in year 2013 and another in year 2014.

For each of the "Sonde_Names", I need to generate a list showing the number and duration of events where the pH is below a value of 5.5 (the field "BlwThresh" indicates which records are below 5.5). An 'event' is defined as one or more contiguous values of 1 in the "BlwThresh" field. This list also needs to include the associated values for "Sonde_Names", "Year", "Month", "Day", and "Hour", in which the event began.

(If possible, the "Event_num" field should reset to a value of 1 when starting to process each unique set of "Sonde_Names" and "Year" values.)

The worksheet named "tally_duration" shows a few manual examples of the objective.

Many thanks in advance for a (hopefully portable) automated solution.
0
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?
0
Using Excel, seems like there is a way to BOTH freeze the top row AND a column to the left using some combination of:

Split

&

Freeze

Not VBA  code, but using the main features of the program itself.  However, can't figure it out.  What am I missing?

Thanks!

OT
0

Microsoft Excel

134K

Solutions

38K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.