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

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
11 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
9 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
20 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
23 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
23 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 ...
0
votes
1answer
13 views

Excel 2010 - Creating a line graph for trend analysis of faults

I have an excel spreadsheet that currently tracks fault reporting in our building. I am looking to do some form of trend analysis ideally to track the faults on the spreadsheet and then display them (...
0
votes
0answers
14 views

How to add 2 on click functions in excel

I have the following code which copies values from one sheet to another when pressing B2. I have 20 different cells I want to be able to click which shall the display various texts from different tabs....
0
votes
1answer
38 views

.csv file from Excel vs .csv file from Libre Office

I created a simple .csv file with Excel which looks like this: I also created the same .csv file by using Libre Office.Both .csv files are looking absolutely the same at TextEdit:id, questions1,...
0
votes
0answers
9 views

Is there a solution to the constant unhandled exceptions that Powerpivot throws in Excel 2013?

Each time I perform certain actions with Powerpivot in Excel 2013 it throws an exception about not being unable to cast a COM object to an interface. This happens most notably every time I try to type ...
0
votes
0answers
19 views

How create a nested drop down in Excel?

Basically, the drop downs consists of:Region - Independent from OthersProvince - Drop Down that depends on Region with reference with Region IDMunicipality - Drop Down that depends on ...
0
votes
0answers
25 views

Error when importing .xslx/.csv file to MySQL database

I have a simple .xlsx file which I filled in manually and which looks like this: When I open this file in TextEdit nothing shows up and (therefore) this file cannot be imported to the MySQLServer at ...
0
votes
0answers
12 views

Can an OLEDB connection string getting data from Access located in Dropbox to my Excel file cause sync problems for the users using the Access file?

So I have created a system at our office where I would use cloud computing systems (mainly Dropbox and Google Drive) to pull data daily. The system is as follows:Step 1 (If the file is not in the ...
0
votes
2answers
17 views

Using Lookup in Excel to populate column

I'm trying to use the LOOKUP function to fill a "fault type" column based on what the "fault description" is. I'm currently using the formula=LOOKUP(E2, M3:N17) which is returning a value from my ...
0
votes
0answers
10 views

Using excel height values to make a 3d heightmap in blender?

I'm working on a project that involves using a colored stick to measure the height of all the marked points in a box. In excel, the values are like this:-800, -750, -500, -200, 0, -300 and so on. ...
-1
votes
0answers
18 views

Excel - Output based on pull down menu, macro buttons, and text input

Rough sketch of what I'm looking atThe picture is a rough sketch of what I am attempting. I am working on a worksheet that the user can track purchases or sales of finance stocks. The stock name ...
0
votes
1answer
23 views

How can I make a proper graph from GTimeReport's google calendar excel file?

With GTimeReport, I downloaded a report of all my activities from google calendar in excel format.The report looks like this:Example of GTimeReportIn the column 1 (see picture above) is a list of ...
0
votes
0answers
13 views

Sync Excel files between PC (Windows 10) and Android [on hold]

I have searched a lot for ways to sync an excel file between my pc and my android, but i haven't found any solution. There are some apps but they are not good enough. Is there a way (without clood) to ...
0
votes
0answers
29 views

How do I keep an Excel formula from changing the sheet it refers to?

I am trying to add a formula in an excel document which needs to access data from separate sheet (in the same book), but it keeps trying to refer to another book. I created the formulas in a different ...
-5
votes
0answers
29 views

EXCEL tasks vba macors [on hold]

i have two cells valve in excel on cel contain A1=surendra,vba AND B1 CELL CONTAIN B1=VBA TASK IS MISSING VALAVE IN C1=?EXCEMAPLE OF OUT PUTA1 B1 C1SURENDRA,VAB,123145 ...
0
votes
0answers
14 views

convert word in italic in multiple rows using excel-macros [on hold]

i have one definition column with 400 rows which contain some description. the description consist(→) arrow,all those word are point with this → i want make them italic,how can i do that using macro. ...
1
vote
1answer
52 views

Excel: How to delete all text to the right of specific string

I have a bunch of web sites in a list, with junk characters after the .com/.org, etc. I need to remove all characters after the .com/.org, but keep the .com/.org. For example: these sitename.com - ...
1
vote
1answer
35 views

Excel 2016 Find and Replace with miscellaneous character

I have a set of data that was imported from a pdf. When the data was brought into excel, it placed a period instead of a comma in a number. For example 1.334.10. I can find the problem with the ...
-2
votes
0answers
14 views

A bunch of unicode characters appended every time i copy/past from mac excel 2016?

So this seems to happen every time I copy about more than a few hundred rows (2 columns) from an excel file to a web form. Seems to have started after I updated Excel for Mac 16.12 (Mac: Sierra 10.12....
0
votes
1answer
22 views

Excel formula with 3 conditions and three outcomes

Let me start off by saying I am not an Excel expert. I have been able to figure out most of the formulas thru research and trial and error but this one has me stumped. I need a formula that does the ...
0
votes
1answer
12 views

How to keep this format while deleting cells?

I would like to copy and paste the "Population" and "Area" columns from this Wikipedia chart:As can be seen, the area column contains both sq km and sq mi. This is a problem, because when I paste ...
0
votes
1answer
20 views

Auto-update Excel cell size in response to dynamic content

Context: I have a sheet with a drop-down with different categories. The sheet also has a table whose information updates depending on what category is selected from the drop-down. Some of the ...
0
votes
1answer
27 views

Get the topmost value from the second column for each unique id in the first column in excel.

I have a sheet in excel with the data in columns A and B set out like this. I have data in other columns as well, but I just need the values in A and B. The data in the columns look like this. A ...
0
votes
1answer
18 views

Excel Chart set axis units as 1, 25, 50,

I've not been able to find to a solution for this.I plot some data as an X Y (Scatter) chart and want the horizontal axis to begin at 1 and then show the units which are multiples of 25, i.e the ...
2
votes
1answer
35 views

How to format Excel numbers so that >=0.1 has 1 significant digit, but < 0.1 has two significant digits?

I'm trying to figure out how to format numbers in Excel to display as follows: If the number is >=0.1, there should be one digit after the decimal place, rounded up, but if it's < 0.1, there ...

153050per page