Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
0answers
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
2answers
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
0answers
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
0answers
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
0answers
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
2answers
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
0answers
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
3answers
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
0answers
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
2answers
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
1answer
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
2answers
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
2answers
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
2answers
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
0answers
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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 ...