A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

0
votes
0answers
9 views

Excel: Compare 2 tables and extract rows from both with a duplicate value

I have two sheets listing out customer name, date, invoice number and comments in columns. The data in both of these sheets are different and in a different order. How would I cross reference column A(...
0
votes
1answer
8 views

Microsoft Query can't find tables in the Excel file

I'm trying to get a 4-column cross-merge in Excel to properly show all of the possible combinations for a thing. (Location, Step, Type). My research indicated that using a MS cross-join query was the ...
0
votes
0answers
22 views

IF Function in Excel (or any other function that would work better)

I am looking to create an IF function in excel using dates and want my expiration column (J1) to be 5 years after the latest date applicable. The following below is what I want to be returned in ...
0
votes
0answers
9 views

Weird Excel Bug?

I have an Excel dashboard (no VBA) that connects to external platform and via some DLLs displays live data into the cells. Many people are using this dashboard (100s) and everything works great. But 1 ...
0
votes
0answers
14 views

shifting a load of Electric Vehicle to the next row if a condition is not fulfulled in excel

I am making a scenario in excel where Electric vehicles are being charged in a given time range. i have a neighborhood loads and the load of EV at specific times. the cable capacity is 50 kW (means ...
0
votes
0answers
10 views

Ribbon - Triplicate macros being created for no reason

I've added some macros to a custom group in the ribbon. It is all fine, and works as expected. However, I've noticed if I go back in to customize that group, I end up with triplicated macros and I'm ...
0
votes
1answer
18 views

“=SUMIF” Formula not working with 00/:00 formatting

Good Morning,I have a spreadsheet I am working on and need to have the total time spent at a location automatically be calculated depending on the start and end time. It works if I keep the ...
1
vote
2answers
16 views

Can I make Excel highlight a cell dependent on sum of 2 other cells?

I have a list of prices in a spreadsheet(numbers input manually). There are 2 seperate cells that show a) length of contract in years (1-5) and b) number of services required annually (2-12) What I ...
0
votes
1answer
7 views

Split data into new column

As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket ....
0
votes
0answers
8 views

Excel Hyperlinks against Outlook Hyperlinks?

I have some Excel Hyperlinks to a website. I log in to the website.When I click the Hyperlinks in Excel they go to the Login page of the website. When I cut and paste the links from Excel into ...
0
votes
0answers
10 views

Issue With Converting Dates to Their Serial Number in MS Excel

Basically I am trying to convert dates(linked here1) to their serial numbers in order to use the=DATEDIF function. However, as you can see in the attached images, some dates do convert and some don't(...
0
votes
0answers
16 views

Excel bar chart with gradient values (not percentages) and value lines

I am trying to create a bar chart that has a gradient fill specific to static values and then a line to indicate the actual value.My data is like so:Name TimeA 16B 33C 40D 45And ...
0
votes
0answers
15 views

Matching Random time entries with a time seires

i was previously facing a problem in generating random time values when the time crosses midnight e.g. 11pm to 5 am but it was solved with the help of one user here. trick was to add 1 to the formula ...
0
votes
0answers
21 views

Excel - Search for specific text and delete the cell data, without affecting other columns

I have the below sample data set.Col A Col B Col C Col D1 WB WC WD WE2 WB xx WD WE3 WB WC WD WE4 WB xx WD WE5 WB WC ...
0
votes
0answers
23 views

How do I count the result of a selection from a VLOOKUP and add the next sequential number to each one?

I have a spreadsheet for actions (Corrective, NCR, IMP, etc.), and need to have it automatically count the types of actions raised to create individual action numbers. I have used VLOOKUP to be the ...

153050per page