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: Getting FALSE, when the value is in the row array

I have a table where I want to pull data based on the row and column labels. So I'm using the INDEX MATCH with arrays in the MATCH function but I keep getting a #N/A because C1:K1=K1 is FALSE. Why is ...
0
votes
0answers
11 views

Can I add additional data to embedded excel graph in PowerPoint?

I have a simple graph with 2 lines embeded in PowerPoint. If I want to add new data like a new month, I can just add these in Excel. However I now would like to add a new line. But it seems not ...
0
votes
0answers
16 views

Make scoresheet from game results

I have a sheet with columns like this:Game NumberPlayer NumberPlayer NamePlayer PointsAnd I need some magic to create (dynamically updated) sheet withPosition (1..n based on ordered total ...
0
votes
0answers
11 views

When Using Index Match In VBA it returns a 0 when the cell is actually empty and should return “”

I have a file that when opened it clears alot of the data automatically and because of this I need to insert an index match formula by using VBAThe formula I have (semi-working):With .Range("r7:...
0
votes
1answer
15 views

show two data in the same chart

I have a problem with excel on my mac.I have two different X-axes with 2 different Y-axes that I want show them in one chart, but I can’t and here is my excel file.
0
votes
0answers
12 views

VBA - Regex & Replace

I am very New to VBA. Below is my code to identify & remove only those dots which are appearing after dates and not after the text. But it does not seem to work. Sub simpleRegexSearch()...
1
vote
1answer
21 views

Is it possible to hide a sheet using excel formula

I have a scenario to hide the sheet based on the cell's value. Using the macro below I can able to achieve this.Private Sub Worksheet_Change(ByVal Target As Range)If [G1]="Yes" ThenSheets("...
0
votes
1answer
13 views

How to get cell custom rgb color in excel?

I have a worksheet with different cell colors (a few rows) and I have to set all rows with a custom color (from the first row). How can I get the first row's custom color and set all rows with the ...
0
votes
1answer
13 views

How to detect if a number belongs to a sequence in Excel

I have a sequence of numbers starting with 6 and then increasing by 60: 6, 66, 126, 186, ... How can I know if a number I input belongs to this sequence, and indicate that in some way, such as ...
0
votes
1answer
15 views

How do I create a macro to show/hide rows based on a dropdown list?

Tried to follow some advice based on a previous post (VBA code to hide or unhide rows based on a cell value) to create a macro so that I can show/hide certain rows based on a dropdown list. I'm pretty ...
0
votes
1answer
12 views

How do I create a 3d chart in Excel where three columns represent the three axes?

I have a data series of three columns where each column represents an axis. For example:X | Y | Z| |-1 | -1 | 5-1 | 0 | 4.9-1 | 1 | 5.10 | -1 | 4.80 | 0 | 5 0 | 1 | 5.2etc....
0
votes
0answers
12 views

Excel track dates and payments

I just got the job of finance/accountant at a Social Club (sports primarily), that has around 150 members. The thing is I have to track all the monthly fee payments, that everyone has to pay let's say ...
0
votes
0answers
22 views

Convert daily personel planning to week number

We use to get a year planner divided in weeks for our crew; now the office format is in days.And our OCD can not handle this so is there an easy way to transfer the data to the old sheet?
-1
votes
1answer
24 views

Excel; How do I import CSV table as rows seperated by table number?

So I have a MASSIVE data set, in its unprocessed format it is a CSV file and contains two column tables that are stacked on top of one another. in the picture below the delimited version of the file ...
-1
votes
0answers
24 views

Taking into acount, that I am only in Mounth #4 (april)

I'm trying to calculate that month in my budget, with the lowest cost. But, I do not know how to make reservations that we are not yet in May, why it will be the cheapest in the smoke.Here's my ...

153050per page