**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

64 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

25 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

21 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

19 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

**0**answers

42 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 ...

**1**

vote

**1**answer

22 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

16 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

14 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

39 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 ...

**1**

vote

**1**answer

35 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

24 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

86 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

46 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

19 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?

**1**

vote

**2**answers

22 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

12 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

20 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

27 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 ...

**-1**

votes

**1**answer

19 views

### Macro to open word through excel

Sub test()
Set myWorkbook = Application.Workbooks.Open(Filename:=[B1])
On Error Resume Next
myWorkbook.Sheets(Cstr([D1])).Activate
On Error GoTo 0
End Sub
How the above macro works :
...

**0**

votes

**1**answer

44 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

61 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

44 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

27 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

12 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

60 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 ...

**0**

votes

**0**answers

27 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

40 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

22 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

**3**answers

62 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

28 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

49 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

34 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': ...

**1**

vote

**2**answers

23 views

### Excel: Format rows in sheet B based on value in sheet A

How do I shade an entire row on tab 2 when an "X" is placed in column "A" of the same row in tab 1?

**-2**

votes

**2**answers

30 views

### Not able to open excel file

My excel file(shortcut) is saved with file extension .lnk and I m not able to open it so I want to know how to open it or how to remove .lnk extension.

**0**

votes

**2**answers

30 views

### Excel Equation: How to skip cell value if row header contains certain text

So I have a workbook for tracking my inventory in real time. It's a really bad bandaid for a problem I cannot have addressed at the moment, so bare with me.
The issue is, I want to have my inventory ...

**0**

votes

**0**answers

25 views

### Formatting of dates in cell using Excel to show result as numbers

I am working with calculating the difference in years, months and days between 2 dates. My results are showing as eg. 32 years, 9 months, 3 days. How do I format the cell to show a result 32 9 3?
I ...

**0**

votes

**1**answer

43 views

### Search cells in excel [closed]

I have an Excel workbook with multiple worksheets. I'm using Excel 2013. First worksheet contains the list of items.
The other worksheets contains the same items but in scattered fashion (with lot of ...

**-1**

votes

**2**answers

40 views

### Excel addins for office 2013 [closed]

We have on hand some custom-made Excel add-ins that were designed to work with Excel 2003. We would like to upgrade to Office 2013, but the add-ins do not function properly in the new version. Is it ...

**1**

vote

**2**answers

51 views

### How to avoid opening a workbook referenced in vlookup between 3 workbooks

Situation:
I have three excel workbooks of which Workbook1 and Workbook2 contain my data. In Workbook3 there is a VLOOKUP which references to the data in Workbook1 and Workbook2.
All of that works ...

**0**

votes

**1**answer

34 views

### How to check if a date is within a given range in Microsoft excel [closed]

I have a data sheet with 6 columns which shows location, class, code, plan, start date, and end date. These dates show the block dates that needed to be illustrated in another sheet. I need a formula ...

**0**

votes

**0**answers

15 views

### how to use =TEXTREVERSE() of morefunc add-in in Excel 2013?

I recently installed morefunc add-in in Excel 2013 but I don't know how to use it.
I saw tutorial to use it in Excel 2003/2007 but I can't find the way to use morefunc in Excel 2013.
how to use ...