**1**

vote

**0**answers

30 views

### Excel 2007 =Hyperlink issue. Calling an EXE with a / switch. The “/” turns into a “\”

I'm trying to run a program from a spreadsheet using the =HYPERLINK function. The formula looks like this (I'm using DIR just as an example so people can recreate the issue if they want):
...

**0**

votes

**2**answers

23 views

### Excel related query for the merging of data

i my worksheet there is several name in Colum A in which many of then are same and i want to merge all the same name along with the numerical data present in there respective colum B
plz help me

**0**

votes

**1**answer

23 views

### Excel file information shared over LOOKUP formula [closed]

In Excel, I have a Vlookup to a shared drive that only 3 people have access to. But other people who do not have access to the shared drive are also able to access this data
For Example:
I type in ...

**0**

votes

**1**answer

31 views

### Excel VBA: Is there a command for printing to PDF (doPDF ver 7)

As the title suggests... I'm looking to expand my automating to include directly printing to PDF. The macro(s) I have written already formats the print area and page setup as I need it. But when I go ...

**-1**

votes

**1**answer

34 views

### I need a cell to automatically fill when data is entered into a neighboring cell

I would like cells E5-E39 to automatically fill with data in cell P1 when data is entered into cells B5-B39. So when something is entered in cells B5-B39, E5-E39 are auto filled with the info in P1.
...

**0**

votes

**0**answers

9 views

### Capture user ID of last updated cell in Sharepoint

I want to track who is changing what values in a spreadsheet I have uploaded to Sharepoint. Is it possible to capture the id of a user who last updated a particular cell?

**1**

vote

**2**answers

53 views

### I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula.
Thanks.

**0**

votes

**1**answer

24 views

### excel formula to return value based on multiple criteria

I am looking for a formula that can search a table like the below and return on a different sheet a currency rate if i input the date. For example in a different excel i will put 2015.03.08 and i want ...

**0**

votes

**1**answer

20 views

### I need the number in a cell to countdown when data is entered into other cells.

I'm making a sheet to keep track of the number of software licenses.
In cell B1 I have the number 35 representing 35 licenses. As they are assigned to systems in cells C5-C40 I would like the total ...

**0**

votes

**0**answers

9 views

### Is it possible to select an cell-defined range (such as September to December) from a set of data in Excel?

I am trying to create a spreadsheet in Excel that basically help me on counting my total daily allowance and takes account on leap years and number of user-defined "number of holidays" (where I don't ...

**0**

votes

**2**answers

25 views

### Auto update Excel databse

I am using Excel 2007. I have an Excel file that has cell A1 showing a date and cell B1 showing an amount in sheet 1. I need to automatically update the date in A1 and amount B1 in a database in sheet ...

**0**

votes

**1**answer

15 views

### Images gets distorted when copy/pasting between spreadsheets in Excel (Mac)

I have two spreadsheets with different row heights and cell widths. When I copy rows from spreadsheet #1 to spreadsheet #2 the images get distorted in an inconsistent manner (some end up just a few ...

**0**

votes

**1**answer

24 views

### Window flashing in and out of focus [closed]

We had a Microsoft Excel window acting strangely - it was flashing in and out of focus, we were unable to select anything in the window - no menu items, no cells, no buttons - nothing. The only things ...

**0**

votes

**0**answers

35 views

### excel - how to count number of names in a column, name is specified in a cell

I have two worksheets, "Clients 2014" and "Receipts 2014".
The receipts have client names for each row (each row is a receipt).
The search key is in the "Clients 2014" worksheet.
I want to ...

**0**

votes

**1**answer

18 views

### my excel 2007 is not subtracting. when I press = it goes to the top line instead of under the sum [closed]

my excel 2007 wont subtract when I press = sign it goes into the top line of the sum instead of underneath the sum.

**1**

vote

**1**answer

18 views

### Microsoft Excel - auto generate date based on number of contacts in a company

I have a 50,000 row spreadsheet with information such as company, names and dates. Every company has a starting date of 4/8/15 and successive entries in the date column (within each company) are 14 ...

**0**

votes

**0**answers

14 views

### Excel - Grouping Columns in pivot table

I am having trouble grouping columns in a pivot table.
1.There are no blanks in the rows for the columns I am trying to group.
All fields have been formatted as General
The Range of the Pivot ...

**0**

votes

**0**answers

8 views

### Auto fill series in groups/sets in excel [duplicate]

I want to fill up a column of values such that the index is incremented after a group is indexed. So, for eg. if the group size is, let's say, 4; the indexing will be:
1
1
1
1
2
2
2
2
3
3
3
3
.
.
.
...

**0**

votes

**1**answer

12 views

### Excel pivot table breaking up for whole number items

I couldn't think of a better title. Please bear with me!
I have the data as the following image shows:
I create a pivot table using the range 'Sheet1'!$A$1:$E$33. The table displayed is as ...

**0**

votes

**1**answer

32 views

### Trying to highlight unique values across multiple sheets in Excel 2007

I am trying to compare the values from column A of Sheet1 (which I have renamed "AR") and column A of Sheet2 (which I have renamed "Paste Here") and highlight rows containing values that do not exist ...

**-5**

votes

**2**answers

31 views

### Formula for Percentage [closed]

I need to get the percentage answer in same cell
A1 5%
B1 100
C1 200
C1 300
I need to keep on changing the percentage and display the changes on the value and not able to add formula in the value ...

**1**

vote

**1**answer

28 views

### Excel 2013 - Creating 2-data series chart with column width is dynamic (depend on variable)

Using Office 2013 suite (Excel 2013), how to I create x/y graph, we additional dependencies where X columns widths dependant on additional value?
For example, from values such as:
Height Width
...

**-1**

votes

**1**answer

23 views

### Excel 2010 open more than one spread sheet in same window

How do I open more than one spreadsheet in the same window so that if I close one the others stay open or if I close the last one Excel stays open? Thank you.

**0**

votes

**2**answers

29 views

### SUM of the logical array

how to sum logical array?
if I use =SUM(TRUE,FALSE,TRUE) it give 2
Now, Let the cell A1 is abcdea & I used =IFERROR(MID(A1,ROW(A1:A11),1)=MID(A1,LEN(A1)+1-ROW(A1:A11),1),0) and then checked by F9 ...

**0**

votes

**3**answers

78 views

### How to find a number after a character in VBA

How can I find a numeric value after a character in the same cell.
For example: Find number 01 after J*. I have a few rows and in each row are value like J*01 or J*08.
Currently I'm trying to ...

**1**

vote

**2**answers

41 views

### Excel data layout

I'm wanting to make a chart similar to this:
The data i'm working with is different but the concept should be the same. I'm most curious in how to group x-axis (category) values. In my case I will ...

**0**

votes

**1**answer

18 views

### How do I create a conditional format with 2 columns

I am trying to create a rule that would highlight a cell under these conditions:
Column B>1 & Column C=O
I want Column C to highlight if they meet these two conditions. Can someone help?

**0**

votes

**0**answers

42 views

### Referencing a cell from another sheet [closed]

I've got a sheet named 'No.of Mails Data'! where the data is
and i want to use my formula on another sheet
=OFFSET(INDIRECT((CONCATENATE("B",(COUNTIF($B:$B,"*")-6)*6+2))),,,30,1)
this is the ...

**1**

vote

**2**answers

21 views

### How to replicate efficient pasting from delimited text behavior in Excel?

Sometimes when I paste space delimited values from a text file into excel it automatically separates them into the correct columns. Other times I have to use the "Text to Columns" tool. I haven't ...

**0**

votes

**1**answer

19 views

### How to return the name of uniquely named sheet

So I've searched high and low and cannot seem to find an answer to this question. Spent almost two days trying every thing I could find on line, but none were specific enough to my situation. Without ...

**0**

votes

**1**answer

10 views

### Any addins in excel to display scientfic notation as written

Are there any addins in excel to display scientfic notation as written?
I want to see 5 x 10^-23 instead of 5E-23

**0**

votes

**1**answer

17 views

### Excel VBA embedded FOR Loop to exclude cells from the outer conditional

Starting with the following code:
Dim lastRow As Long
With ActiveSheet
lastRow = .Range("C" & .Rows.Count).End(xlUp).Row
End With
Dim HeadCell As Range
For Each HeadCell In ...

**0**

votes

**3**answers

20 views

### I need to make a master Excel workbook that references other workbooks so I can search for items in one place instead of multiple Excel sheets.

I have co-workers that keep track of product they work on using an Excel workbook, each person has their own. Currently if I want to find out who worked on an item, I have to search each workbook ...

**0**

votes

**1**answer

24 views

### Excel Timeline Chart (Vehicle Tracking)

Using Excel 2010 I understand how to create a Gantt Chart to simulate a timeline. Very similar to this https://ablebits.com/_img-blog/_comments/gantt-chart-months.png.
My task is a little bit ...

**0**

votes

**1**answer

35 views

### Excel VBA: How to find last row of a worksheet containing actual data

I know how to find the last row of my worksheet that has any type of data or values
Dim lastRow As Integer
With ActiveSheet
lastRow = .Range("B" & .Rows.Count).End(xlUp).Row
End With
...

**1**

vote

**0**answers

36 views

### How to calculate average daily sales for each month in a pivot table

I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573.
However, when Excel calculates these values in a pivot ...

**1**

vote

**0**answers

12 views

### Refresh data in depth trough multiple closed workbooks

Situation
I have 3 Workbooks in the format .xlsx, Source, Manipulation and Result.
Result has a link to a cell in Manipulation wich again, has a link to a cell in Source.
As the data is manipulated ...

**0**

votes

**1**answer

22 views

### How to fix a database after sorting only a few columns when other columns were hidden

I have sorted a giant database with lots of information when several columns were hidden. One of the columns was sorted by date and when I unhid all the columns, half of all the information in the ...

**0**

votes

**0**answers

10 views

### Excel Powerview plot Summation of Multiple Series

Currently, I have a PowerPivot Data model based on the following table:
My corresponding data model is shown below. I have a calculated column which keeps running totals for each contractor's man ...

**1**

vote

**2**answers

39 views

### Excel formula to convert date formats

Assuming I have cells that have text values mentioned as:
02/23/15 to 03/01/15
Can I use excel functions to convert this to something like
23-Feb-15 to 1-Mar-15
So far I have looked at formula ...

**-2**

votes

**0**answers

30 views

### How to find a perticular information among the 10 work sheets in excel [closed]

I have 10 nos of excel files and i want to find a particular information among them.
Fields are similar in all the files and fields are as like;
enrno, name, program, age, state.
For example; ...

**0**

votes

**0**answers

20 views

### How to show all the worksheets on user form in vba?

I used my code to open up workbook, after I select the workbook, I want to prompt user form which will display all the worksheets which belong to the workbook. Here is my code:
Function ...

**0**

votes

**0**answers

14 views

### Excel Template Show Associated Tasks

I found a template in excel 2013 called "Weekly Time Planner". It has a mechanism that filters another table when clicking upon a certain item. For example, I select one project in the project ...

**0**

votes

**0**answers

17 views

### Combine table in Excel

I want to do a training matrix in Excel and track its completion.
My fist table represents all the documents on which we should (or not!) be trained related to job title.
Doc Name | For all ...

**1**

vote

**2**answers

38 views

### Multiple IF Statement

I have a question about IF statements.
I wanted to use VBA, but the other guy I am working with doesn't know how to do it, so I am trying to only use worksheet formulas. So, I figured the best way ...

**0**

votes

**0**answers

21 views

### Changing font of bilingual (Chinese & English) text in Excel

I have a large Excel file containing both English and Chinese text. I would like to change the font of the English text but whenever I do so, the Chinese text switches to another Chinese font, which ...

**0**

votes

**2**answers

49 views

### Excel SUM is not equal to manually-typed value

In the screenshot above in Excel I have opened a CSV file of money transactions from my bank. The transaction date is in column A, the amount in B, and the bank's computed balance in D. I'm ...

**0**

votes

**0**answers

23 views

### Excel LINEST returns #REF error when using non-rectangular array

I'm trying to use the LINEST() function on a named range. The function seems to work fine when the named ranges are typical rectangular arrays. However, if the named arrays are irregularly shaped, the ...

**1**

vote

**2**answers

47 views

### How to I simplify code that combines information and adds up values for certain columns?

I am revamping some VBA code that was done 15 years ago that someone else created. I have to add more code to fit our needs but I exceed the amount of code allowed to run.
I have a Products in ...

**0**

votes

**1**answer

31 views

### Visual Basic Debug in Excel

I had a workbook created for me.
I made a mistake and deleted an entire row from the Master Page and now I am getting a debug error and #REF! on the UC-K sheet.
The error says Run-Time Error '13': ...