**0**

votes

**1**answer

25 views

### Excel 2010 Multiple Conditions and More Than 2 Outcomes [closed]

I need some help!
I have 4 conditions and more than 2 different outcomes dependent upon the condition so strugglig with IF/AND/OR statements. All data is dates. a2 is the reference date:
Condition 1 ...

**0**

votes

**2**answers

92 views

### Update and Append Rows based on Two Criteria in VBA Excel

Could anyone help me write a code in VBA that updates a table, or appends new data based on criteria in two columns?
For example, there might be a name column, and a project column, and we want to ...

**0**

votes

**1**answer

46 views

### Automatically update a filter

I have a graph depicting 3 years of data, and an option to pick which year(s) of data they want to see. I'm pulling the data from a chart that I have put in formulas that change the data to #N/A if ...

**0**

votes

**0**answers

13 views

### How to get excel make a nested outline hierarchy from an index column? format 1.2.3

I have a large set of data that is exported from a database.
In one column there is a index which shows the relations of the datasets.(Just an example)
Name Details Vendor ...

**-1**

votes

**2**answers

30 views

### In MS Excel, what function should I use?

I have an original table:
Class 1 Class 2 Class 3 Class 4 Class 5
Ram Shyam Madhu Peter Xavier
Micheal Cynthia Helen Rama Hema
Peters Veronica Amy Sydney ...

**0**

votes

**1**answer

32 views

### How to preserve custom number formatting after closing a workbook?

I have created a custom format ##,##0.0,,, CTRL+J %% in Excel 2010 to display
10000 as 0.1
100000 as 1.0
1000000 as 10.0
10000000 as 100.0
100000000 as 1,000.0
and so forth.
The problem I am facing ...

**0**

votes

**1**answer

28 views

### How to use =sum function properly in excel 2007?

In the above picture, for the column G7, I wan sum of D7, E7, F7. So, I am using =sum(D7:F7), but excel is showing error for the formula by highlighting a green flag. If I ask it to correct the ...

**0**

votes

**1**answer

32 views

### Excel cannot open the file [duplicate]

Windows 8
I scanned and fixed an external usb drive and lost an excel file
The file did not want to open as it had the following message :
Excel cannot open the file ... because the file format or ...

**-2**

votes

**1**answer

53 views

### Excel - Need to get a figure from one worksheet to another (it's complicated) [duplicate]

I have an Excel workbook with 2 worksheets.
One worksheet is for the input of stock transactions, the other has an overview of the portfolio.
So on the portfolio worksheet I would like to have a ...

**-6**

votes

**1**answer

40 views

### Why is the IF function not working? [closed]

I have a problem in excel, I want to make mathematical equation, I've tried it and I have problem with that function, it gives me error. I want have result in G6
if i type W in F6, then it will type ...

**0**

votes

**0**answers

35 views

### excel 2013 repeating equation on all rows

How do we repeat an equation on all the rows? Endlessly, as we enter data in other columns of the row, I want equation to calculate. Technically creating a new row everyday but I want to calculate as ...

**0**

votes

**1**answer

20 views

### Determining which column is visible to the right of a frozen pane in VBA

I'd like to determine in VBA which column is shown directly to the right of a frozen pane, in the example image, it would be column G.
See the picture for reference.
Any ideas?

**-1**

votes

**0**answers

17 views

### Excel: VBA Buttons - Search/Criteria Button Coding that will allow all fields to be populated and edited

I am building a data storage system for a business. We have three types of data interest and thus three worksheets -customers, sales, and processing. Some data is referenced across worksheets, ie ...

**-1**

votes

**0**answers

12 views

### Excel issue: how to do a filtered copy from one spreadsheet page to another

I would like to copy, or not, lines from one page of an excel spreadsheet to another page on the basis of the value in a cell in the first page. I've never done any coding (shame on me).
Here is the ...

**1**

vote

**1**answer

14 views

### How do you create a bracket tournement sheet on excel [closed]

I am trying to create a bracket sheet that automatically moves a teams name to the next cell
example:
Team 1 in cell 'a1', Team 2 in cell 'a2'
The score for each team in cell:
'b1' for Team 1, 'b2' ...

**0**

votes

**0**answers

6 views

### Search/Find option not working on excel 2010

I have number of dates written in a row in ascending series, DD-MMM format, excel 2010, under custom option format.
And I am trying to search/find a particular date, which already exist in that row ...

**0**

votes

**1**answer

29 views

### How to find last row that has same value as my last one and output the number of that row?

I have a worksheet with stock transactions, so in column C I will input the name of the stock that I'm buying or selling at a given time.
.....A.....|....B....|...C....|
DATE | TYPE | STOCK
...

**-1**

votes

**0**answers

13 views

### Is it possible to import an amendment file into Microsoft Access?

I'm having a tough time trying to figure out if it's possible to import some sort of amendment file into a known Microsoft Access database and have it update the original data that was imported.
...

**1**

vote

**1**answer

38 views

### Spreadsheet data harvesting

I have an Excel spreadsheet (.xlsx) with multiple rows and columns of cells containing space-separated text. For example:
A1 the good of the many
B2 all dogs go to heaven
C3 eat my shorts
I ...

**0**

votes

**1**answer

15 views

### Hiding Date in Formula if nothing is entered

I want to have a Date forumla that adds 7 days to a date entered in another cell, but if nothing is entered I would like said cell to be blank
A1 if blank then have B1 blank
A1 is 2/1/2015 then have ...

**0**

votes

**1**answer

23 views

### Finding an exact match for a dataset in Microsoft Excel

I have a lot of numeric data in one column that I have pieced together from various other worksheets.
I found some data in another worksheet that may be a copy of data I already inserted into the ...

**0**

votes

**1**answer

51 views

### Is it possible to sort a table by entry modification date? Specifically, how to access from VBA the last modification time of an object?

I have a MS Word document where I accumulate and frequently modify certain data in a very long table. So I would like to sort the data by latest modification time in the rows. Of course if I add a ...

**1**

vote

**0**answers

20 views

### finding data with multiple conditions and replacing it with new data

I am working with 2 worksheets, 1 contains all my raw data and the other works as a dashboard with my pivot table and charts.
I hope you can help me create a cell input range in my dashboard ...

**1**

vote

**0**answers

31 views

### Microsoft Word, Powerpoint, Excel adding unnecessary letters while opening a file

Downloaded and opening a word file from web add the this kind of formatting at the end of each paragraph. What is the reason?
Here is the image to let you know the problem
...

**0**

votes

**1**answer

22 views

### MS Excel formulas displaying #REF when data is entered in a cell in a certain way?

I have various complected formulas pulling data from two pages (used as data entry pages), formatting it in specific ways, and displaying it on another third page (all in the same work book).
This ...

**-1**

votes

**0**answers

20 views

### Vba Excel to click a browser link not working

I made a Macro that successfully logs in to my company's website, however I cannot navigate through the rest of links.
After loggin in, the addres becomes ...

**0**

votes

**1**answer

39 views

### Description from one sheet into comment of another sheet in Excel

what i have an excel with incoming on one sheet and code descriptions on another i would like to auto create a Comment displaying the description of the incomming codes or is this possible.
ex.
...

**-1**

votes

**1**answer

14 views

### Setting a specific xlsx file to always open a unique EXCEL.EXE process

I have an excel file that contains some visual basic forms used for data validation and entry. However, I'd like to be able to copy and paste from other open spreadsheets occasionally. The problem is ...

**-2**

votes

**1**answer

77 views

### Excel VBA copy value to new

I'm brand new to VBA and macros. I've been stumbling along rather decently, but I've come across this problem and I'm not sure how to tweak the code.
I need the user to be able to enter a value ...

**0**

votes

**0**answers

14 views

### Comparing data from two identical pivot tables

Is it possible to compare two separate pivot tables that have exactly identical row and column names (obviously differet values), either in a another pivot table or some other way?

**0**

votes

**0**answers

18 views

### Is there a way to recover a document if the document has never been saved for Excel 2007?

I unchecked the auto recover box by accident and in the middle of my calculations my computer crashed. Is there a way to recover the workbook I was working on when it crashed? I never got the chance ...

**2**

votes

**4**answers

2k views

### Excel runtime error “32809” corrupt workbooks?

Currently facing an incomprehensible issue with Excel...
We have developed a work order electronic package that is used by about one hundred users every day. It is essentially the exact same workbook ...

**0**

votes

**2**answers

28 views

### Copying data from an entire column in excel worksheet into another worksheet minus blank cells

Instead of using a copy and paste function is there a way to lookup data in an entire Column rather than an individual cell in one spreadsheet and list it in another ( minus the blank cells )so it ...

**1**

vote

**1**answer

16 views

### Searching for Re-occurances in EXCEL and using those Re-occurances

I am trying to create a function that looks to see if the value of a field, lets say "A1", occurs elsewhere in the "A" column, and then searches the rows of those re-occurances and if any of those ...

**-3**

votes

**1**answer

30 views

### I need some help in excel validation [closed]

I'm not good in excel. I need to include an excel sheet in my page, and I need an expert who can write these custom formulas for cells validation.
1) A column that accepts only letters, no numbers or ...

**1**

vote

**1**answer

33 views

### How do I count multiple words available in sentences and multiple rows (countif, search)?

here is screenshot for the sheet.
https://flic.kr/p/qZb8ot
in column A there are some senteces list below:
A2. T-shirts, Varsity
A3. T-shirts, Sticker, Mug
A4. T-shirts
A5. T-shirts, Pin, ...

**2**

votes

**1**answer

67 views

### What would be the the mathematical equivalent of this excel formula? =PMT()

I need to create a javascript form that does the same calculation as this =PMT() function.
mortgage = 220000
rate= 4.75%
term = 30
The example formula I have is =PMT(4.75%/12,30*12,220000*-1)
What ...

**1**

vote

**1**answer

18 views

### Lookup value based on part of a cell

In Excel, I have a list of tasks (column A) , with one master ID number (Column B)
This master project number is a combination of text and numbers in format ABC.001
I have another list of sub tasks, ...

**0**

votes

**0**answers

7 views

### SUM spread across a series of cells unevenly starting with 0

I have a SUM, let's say it's 5000 users over a 12 months of growth. How do i show this is a series of cells where we start the monthly users at 0 per month and each the new subscribers and end at a ...

**0**

votes

**1**answer

19 views

### How do I get URLs from hyperlinks in Excel 2010?

I have a column of cells with hyperlinks (to web addresses) and I need their URLs to be regular text. Is there a way to extract the URLs from hyperlinks?
Example:
Cell says: "CLICKME"
Links to: ...

**0**

votes

**1**answer

25 views

### Intersect ERROR:Method 'Range' of object '_Global' failed

Why A get this error: Method 'Range' of object '_Global' failed When I Put:
Private Sub Workbook_SheetChange(ByVal WS As Object, ByVal Target As Range)
Dim NTT As Range
Set WS = ActiveSheet
Set NTT = ...

**2**

votes

**2**answers

36 views

### excel: export csv file with japanese character

In my excel file, the Japanese character is shown correctly,
while when I export it as csv,
the character become question marks
How should I output so that the character can be shown correctly?

**3**

votes

**1**answer

78 views

### Excel formula to get first and last non-empty value in a row and return column header

Let's say I have an Excel spreadsheet aggregating votes in some poll over a period of time as per the example below.
How do I find the min and max value people have voted on on a given day (the ...

**0**

votes

**1**answer

20 views

### Excel 2013 global automatic macros

I am trying to log the opening and closing of excel workbooks to replace the Journaling capability in office.
I have created and tested VBA auto_open and auto_close macros in excel, which log these ...

**0**

votes

**1**answer

48 views

### How do I display name in column2 dependent on value in column1?

I am doing an inventory for all the businesses of a street. I have a two sheets, where on one I have different categories for commercial uses.
Each category displayed in sheet 1 has a number (1 to ...

**1**

vote

**0**answers

17 views

### Build comprehensive formula for all precedent cells

Is it possible to build a comprehensive formula for all precedent cells? I'm aware and employ the "Trace Precedents" and "Trace Dependents" feature in Excel often, but this only goes back one "layer" ...

**0**

votes

**2**answers

14 views

### Reformat vertical data to horizontal (side-by-side)

I have a spreadsheet containing groups of data in a vertical format, e.g. here are three "groups", each with five rows:-
I would like to reformat the spreadsheet so the values are all side-by-side, ...

**1**

vote

**2**answers

78 views

### Select elements in an array that satisfy a criteria

The goal: Kappa-Sigma clipping in Excel
I want to implement a selective linear regression formula in Excel (avoiding VBA). I have a data sample on which I need to apply a linear regression. But my ...

**3**

votes

**1**answer

27 views

### Why can't I use a number wildcard to in Cells.Find in VBA?

I'm trying to search my Excel worksheet for any cell that has a value that begins with a number followed by a period, but this isn't working. Does anyone know why not?
Cells.Find(What:="[0-9].", ...

**0**

votes

**1**answer

38 views

### Excel formula related to if statement [closed]

I need a formula which satisfy the following condition:
If A1="Yes", then the corresponding cells B1, C1, D1......etc should contain the word "yes"
IfB1="no", then the C1 should be "no" such that the ...