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
11 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
23 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
10 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
11 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
19 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
8 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
26 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 ...
-1
votes
0answers
9 views

Extract distinct row values from a sheet to another sheet based on max dates per unique rows

I want to extract rows based on max date or max B per unique values of col A and col c. Doesn't matter if it is vba or excel formula. Help please.Old SheetNew Sheet[2
0
votes
1answer
22 views

Excel SUM() Formula Not Working

I have a complex formula: two SUMIFS formula nested in a SUM formula. The concept is to sum amounts given a specific time period and specific account code.This formula seems to work great. I get an ...
-1
votes
0answers
13 views

Excel — Find difference of each store's product price and average of all store's

I have a list of product prices in each store (A, B, C, D, E, F, G stores are all selling Apple, Banana, Corndogs, Doughnut, Earrings, Fig, Gums with different prices). I want to find the difference ...
0
votes
1answer
8 views

How to use VBA .SaveAs by copying a number from a cell in the spreadsheet retaining a particular number format?

In Cell A1, I have the number (56,000), which is -56000 (negative fifty-six thousand), formatted as Accounting. However, whenever I use VBA to include that cell value in the filename, it saves it as "...
-2
votes
0answers
16 views

How would I track payments for a loan with no interest in excel [on hold]

We are lending our daughter some money to buy a car, and we don't intended to charge interest.I can do a simple spreadsheet that can subtract her payments, but I am having difficulty working out one ...
0
votes
0answers
11 views

How can I Transpose Multiple Groups of Rows into Single Group of Columns? + How can I do this across multiple WB at the same time?

I am trying to transpose multiple groups of 4 rows into one group of 4 columns. On top of that, I am trying to do this across multiple workbooks in different folders. My company uses Excel to manage ...
0
votes
2answers
34 views

Is there a way to use excel's VLOOKUP with multiple criteria?

I'm attempting to create an aggregate of data that looks at a list with a lot of duplication of items and compiles a total number that the duplication appears, and a unique value associated with the ...
-1
votes
1answer
19 views

How to group data in multiple rows in Excel?

I need to group data from multiple rows into one row. The issue that I'm having is that I have inherited this data, thousands of rows, and Column A only contains a value when a new data row is started....
0
votes
0answers
27 views

Possible to edit and mirror the same column in two sheets?

At present I'm using Excel and require a column to allow data input from two different sheets, but accept the latest input as the correct value.The workbook has two sheets within it, Sheet 1 and ...
0
votes
0answers
21 views

Vlookup issue | Macro Heavy Worksheet

Hey I am having quite a weird issue with a file a built that is very macro dependent. It centers around a simple vlookupCurrently my macro creates a line item on one sheet (Sheet A), then copies ...
-1
votes
0answers
12 views

What's a faster data extraction software than Oracle's Hyperion Essbase? [on hold]

Been dealing with big data extraction in my company and the time it takes to download all that data is about 30 minutes and sometimes even an hour. It may cause excel to crash, so I was just curious ...
0
votes
3answers
32 views

Better Excel shortcut for current time

Is there a way I can set an easier shortcut for the current time in Excel? I know about "ctrl+shift+;" but I need something that can be used with one hand. Ideally if I could set up and F key to add ...
-2
votes
0answers
8 views

I need to compare two sheets in excel and if email found need to add whole row into third sheet [on hold]

I have three sheets, from sheet one I need to take the email and need to find that email in sheet two and if found highlight that row and move the whole row into third sheet.And then change that ...
1
vote
1answer
19 views

Creating a combo chart with bar and data icons

I'm not sure if this is even possible. I'd like to create a chart like so:My data source is a pivot table with 3 columns - Category, Revenue and Growth (a calculated field).I'm thinking of a combo ...
0
votes
0answers
19 views

Excel - Random uniq number in range

I have a range from 1-72 and I need per column one uniq number and in the next row a different sequence like this example with a range of 6:A B C D E F1 2 3 4 5 62 3 1 6 4 53 1 4 ...
0
votes
1answer
27 views

Auto Calculate Hours for Shift

Good Morning,I am using Excel and have am trying to be able to add a punch in and out time, then have the total time between those automatically be calculated in the next spot.This works when I do ...
0
votes
1answer
10 views

If not match - how to use function, for numbers which cannot be repeated

In Column A I have around 6000 cells with different records, depending on many conditions I need to add one number from Column C to Column B. In Column C I have 3000 cell with numbers/texts (A:G304,B:...
0
votes
0answers
36 views

Generating random time values in Excel [duplicate]

i am having a problem with Random time generation within a given time limit in excel. problem is if i give a time range from morning to evening the formula works great but if i give the time range ...
0
votes
1answer
19 views

Copy data from one sheet's cell to multiple cells in another sheet

I have this database where I store sales. I can find particular sales by filtering. I would like to have a button that then regenerates the sales as "receipts" in another sheet.This is my code for ...
0
votes
0answers
27 views

How to Extract Unique Values From Multiple Columns With Pivot Table?

I have 2 columns in Excel. Some of the content repeats in each and vice versa. e.gA - 1 2 3 5 6 B - 1 2 4 5 7I want to compare these two columns and make a new column or list with the unique ...
0
votes
1answer
28 views

Sending automated email from Excel?

Currently have a shared workbook which has a column with a data validation list, if 'YES' is selected I'd like it to send an email to a certain department to prompt them to look at the workbook. I'...
1
vote
1answer
45 views

Change a function used in a formula, using the function name stored as text in a separate cell

I have this formula=ROUNDUP(D12/(D6-D5),IFERROR(VLOOKUP(G9,reference!$C$2:$D$7,2,0),100))and I want to change the ROUNDUP portion based on text from a separate cell (say, F7, where the text can be ...
0
votes
0answers
23 views

Total of unique numbers in a range on multiple sheets [on hold]

I am using Excel in Office 365 and cannot figure out how to get a total of how many unique numbers are in B20:B200 on four sheets (FY19Q1, FY19Q2, FY19Q3, FY19Q4).
0
votes
1answer
56 views

VBA code for subtraction of subsequent numbers in a list from the first value

I have a list of numbers. I want to use the first number in the list as a starting value and subtract the subsequent numbers from it, using VBA.I have made several unsuccessful attempts:Function ...
0
votes
0answers
11 views

Clustered column graph male/female Excel 365

So I have two columns in a table (more, but two are relevant) A gender column (male or female) and a column where each person has indicated which of 4 drinks they like most (A, B, C or D). I want to ...
0
votes
0answers
19 views

Excel Search that will report back an entire table

I have 4 sheets in my workbook. Sheet 1 is my Search sheet, sheets 2, 3 and 4 are identical format with different data. Each one of these sheets has a varying number on Tables that are all identical (...
0
votes
1answer
15 views

How to tell Excel to wait to update a cell (in order to avoid circular reference error)?

Scenario: I am using a variable in a calculation, which I will call fred. I want to calculate fred by dividing the last non-zero entry in column B by that entry's row number.However, where column B ...
0
votes
1answer
49 views

How to populate a table with data from tables on other sheets using a drop down list

I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions.Example: I ...
0
votes
2answers
47 views

Excel freezes when running macro

Private Sub Worksheet_Change(ByVal Target As Range)Dim KeyCells As RangeDim i As IntegerSet KeyCells=Range("H4:H100")If Not Application.Intersect(KeyCells, Range(Target.Address)...
0
votes
2answers
49 views

How to solve “current printer is unavailable” message on opening workbook?

I have an Excel workbook that, on opening, displays a message "Current printer is unavailable. Select another printer." Followed by a dialogue box with a list of print drivers.Based on this thread, ...
0
votes
2answers
39 views

Count specific items separately in 1 cell

I need a formula like COUNTIF for this problem.Forexample:I write ''a, b, c, d, d'' in 1 cell, but want them to be counted separately like this:a -> 1b -> 1c -> 1d -> 2I tried with ...
0
votes
1answer
34 views

Excel Formula to skip already filled cells

I have a formula I want to fill down to end of sheet, but I already have some data in this column, so naturally my formula stop.. Is there a way to skip already filled cells within the column?=IF(...
-1
votes
0answers
19 views

Hyperion Essbase data extraction

Do macros not work when refreshing data from Hyperion Essbase? I've recorded some macros into a spreadsheet but every time i run it it doesn't work when dealing with data from essbase.
0
votes
1answer
14 views

How to modify data to make box plot?

My data is formatted like: 0:01:11 0:01:58 0:01:12 0:01:33 0:01:140:01:07 0:07:00 0:04:14 0:02:07 0:03:060:01:16 0:01:00 0:02:39 0:03:00 0:03:430:02:26 0:02:57 0:08:43 0:03:10 0:...
-1
votes
1answer
14 views

Scatter plot for multiple rows

I'm trying to plot the following data in Excel using a scatter plotIncome 1960 1961 1962 1963 1964 1965Algeria 1280 1085 855 1128 1170 1215Argentina 5251 5448 5316 ...

153050per page