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 "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
1answer
6 views

Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget. Cells look like this A B C D DATE WEEKLY BILLS TOTAL 2015 $50 $1,956.73 Jan ...
0
votes
0answers
7 views

highlight birthday in a referenced cell

in Excel 2003 in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday in cell A1 date of Birth in cell B1 age with the formula: =DATEDIF($A1,TODAY(),"Y") ...
0
votes
0answers
8 views

EXCEL macro opens document but does not ask to “update links”

I have an WORD doc with links to cells in an EXCEL document If I open the linked document manually, it asks to [Update automatic links] and works perfectly but, when I use the macro ...
0
votes
1answer
13 views

Cells evaluated by user-defined module do not update automatically

I read the questions existing but no answer seemed to help. I have a function I wrote in VB which evaluates sum of cells in a certain range by font color, it all works well when I type the function in ...
0
votes
0answers
14 views

Excel will not put information in cell?

I am entering data in one cell in excel and it will not put information in the cell. Will work in all others however. Started when I was simply trying to cut and paste a confirmation number.Number do ...
1
vote
0answers
18 views

Shortcut for Direction Keys — To keep hands on QWERTY end of the keyboard

I use a lot of Excel and finally got myself used to the ThinkPad pointer whereby I no longer need to take my hands off the keyboard for scrolling. But now I need to take my right hand off the ...
1
vote
1answer
19 views

How to grep summarized value from excel cell range?

I want to get summarize information from the following sheet. I don't know how to summarize this information. My scenario is like this. If I input -6, I want to find my target value in this ...
0
votes
1answer
38 views

how do assign numbers to text and then add or subtract them?

Hi could you advise how i create a formula for the following spread sheet? the text all have same value (AB=1) BC=1) (CD=1) etc. I want to place the text in a cell to place order, the text should ...
0
votes
1answer
16 views

View code in Excel - Import_Journals

I'm trying to look at some VB code in an Excel macro. This code is executed on a button click: Private Sub ImportSelected_Click() Call Import_Journals("SELECTED", "IMPORT") End Sub I want to ...
-1
votes
0answers
15 views

How can I automate the process of printing 2 rows of data from one sheet after pasting it onto the form on another sheet?

Sheet 1 of my spreadsheet has the following form: A B C D They are just columns named 'A','B','C' and 'D'. Sheet 2 has the following data: A 1 2 3 4 5 6 7 8 9 10 I want to print pages of ...
0
votes
0answers
15 views

Replacement of a string in excel with another string, taken from a csv file [on hold]

Say I have a CSV file which looks like "5.2", "Blah Blah Blah" "5.3", "Bleh" "5.4a", "Unicorns" Now, how would I go about creating a script or macro of sorts(?) so that whenever I type ...
0
votes
1answer
18 views

Clamping values while averaging

I have two formulas that are calculated using the same dataset. One formula calculates the average of the values, while the other calculates an average with a maximum allowed value of 60. I'm ...
0
votes
0answers
19 views

Excel Updates Link In Other Workbook

I opened two spreadsheets from an email, spreadsheet June & November. Both June & November in cell A1 reference a [CashInput.xlsx]CashInput$A$1 that was saved on the spreadsheet creator's hard ...
0
votes
0answers
24 views

Split single row into multiple rows in excel

I have a file of data formatted in the following way contractID, typeofreview, rq#, q1,q1a, q2, q2a, q3, q3a, q4, q4a 0001 basic 15 Ht Y Smk Y Sur Y Rsk Y 0001 ...
0
votes
2answers
22 views

How can I find the Maximum of Polynomial Trendline?

I have a XY chart. I used a polynomial trendline, now I need to find the maximum of the chart in an automatic way. Is it possible? Here is a picture to show the type of chart.
0
votes
1answer
25 views

Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file. I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...
0
votes
0answers
26 views

Group different values with same name field in Excel

I'm having troubles with the following document. Is there a way to group different values with the same name field?
2
votes
1answer
25 views

VBA EXcel - I am getting an error (400) if using error trap getting no object/application defined error

My excel sheet has these data, 7 columns sl.no | bed | 2| 4| 3|4|3| some times column no 7 is empty, and then only I'm getting error And my code Sub sup_cal_area_sft() Dim lru, plru As Long Dim ...
0
votes
1answer
21 views

Color a cell in MS Excel sheet, if do not fall in range

We need to enter lots of data in a excel sheet. Later we want to color code that data. I will be the one preparing this excel sheet and sharing with team. What I want is the moment I put a number and ...
0
votes
0answers
10 views

How can I create multiple charts based on a series filter using PivotChart?

I have a pivot table/chart displaying sales(value) by week(axis). I can add the branch to the legend and get one chart that displays the sales by week by branch. The problem is that I have 100 ...
0
votes
1answer
27 views

Excel formula disappears when saving as .xls

I have a long formula in one of my cells. It is: ...
1
vote
4answers
47 views

How do I add 1 year to a specific date once that date has passed?

I have an excel spreadsheet that lists our current subscriptions. I have one column with the Date they signed up and then I have another column for the Renewal Date. Currently I have to manually ...
0
votes
2answers
37 views

If cell contains “Specific Text” return value of cell beside it. Similar to VLOOKUP

I have 2 sheets, one with a list of parts(sku) and all the vehicles that the part will fit on (fitment) separated by "^^" it looks like this: sku | fitment 1 |car1 ^^ car2 ^^ car3 2 |car2 ^^ car3 ...
0
votes
1answer
16 views

How do I insert rows in multiple excel tables simultaneously without vba?

I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible? The tables are in different sheets if that matter.
3
votes
1answer
23 views

Match based on String Length

I have data similar to: My goal to to: find the longest string in column A retrieve the value in column B on the same row so in the above example I want Juliet. If there is more than one cell ...
4
votes
2answers
309 views

Generate Combinations in Excel

I have an input row which contains the cells: 30 30 30 50 50 60 100 I want to generate all possible combinations of length 3 from this set. So I would want rows containing 3 populated cells and ...
0
votes
0answers
23 views

Word Mail Merge with Excel - Can't open both at the same time

I have a word mail merge for letters using an excel file as the data source. My problem is that I am not able to have both files open at the same time for editing (i.e. the excel source data and the ...
0
votes
1answer
16 views

Excel Macro to draw xyscatter plot out VBA

I am trying to create a xy plot where the x values is the time axis (column A) and the y values are in the other columns. (in the example only C and D) When I try my code from below, I get a graph ...
-1
votes
2answers
28 views

how can i make my macro toggle a sheets visibility/hide?

i have the following code that i want to toggle a sheet being visible or being hidden: Sub toggle() If Sheets("Navigation (2)").Visible = True Then ActiveWindow.SelectedSheets.Visible = False ...
0
votes
2answers
26 views

Copying and renaming of .xlsm files using batch

Its glad to be here and i am really excited n new to batch scripting. I have been using a batch containing below for copying an excel from one folder to another { @echo off cp -r ...
2
votes
3answers
19 views

Excel SUMPRODUCT - exclude header cells from formula

I have two columns, one with a date and one with values, and I want to sum up all cells, where the year of the date is the desired year. My problem is, that I have headers in the table, and I don't ...
0
votes
1answer
16 views

Excel Index Match - How to use iferror / indexmatch

I have a Cell like this Postcode 2037 2009 2132 2042 2043 2048 2009 2010 Another Tab 2015 2048 2050 2006 2008 2010 2016 I want the result as - if the postcodes in another tab is in postcode - ...
-1
votes
1answer
21 views

EXCEL: Can I get a count of a certain value from columns with certain headings, only from the columns with certain text?

A screenshot of the spreadsheet1 Hi I am looking for a way (in the form of an Excel formula) that can do this I need to count the number of "o" in columns with headings "Threat", for each row. For ...
0
votes
0answers
39 views

Excel Formula to show All dates in a range after today

I am trying to build a spreadsheet that I am using the lookup feature to take data entered on sheet 1 to locate that data on sheet 3, I need it to then list all Dates after today for the current ...
1
vote
1answer
30 views

In Excel, is text zero or what?

I have a column of numbers that also contains the letter T. If I use a simple IF(A1>0,..., the letter T is treated as greater than zero and produces the "true" result. However, if I use ...
0
votes
0answers
9 views

Auto-Fill data between two spreadsheets, adding new row, keeping same column, when new val

So I have a list of items that need to be constantly added to a list for auditing purposes. Problem is, the item names constantly change and also on occasion, new items are added. Essentially, I am ...
0
votes
2answers
22 views

how can I see what TYPE of data is in my macro?

I have the following code that doesn't work inside a macro: count = Application.Sheets.count ans = type(count) msgbox("count is " & ans) but this doesn't work cause I think type is looking for ...
1
vote
1answer
20 views

Excel make a list with a specific conditions

I work in a hospital, have a list of patients, with name, date of admission, date of dismiss, and diagnosis. I need a list with all data when date of dismiss is blank, if contain something must skip ...
0
votes
0answers
18 views

Excel autocomplete/ suggestion list. Not a drop down

I am using Excel to record various data and some rows have more cells than others. How can I make a list of words for Excel to use to autocomplete when I am entering data manually. I don't need a ...
0
votes
1answer
25 views

VBA warning when cells selected are not equal to 5 and contiguous

My Vb macro does the following: I select 5 contiguous cells, run my macro and I get 5 static random numbers between 1 and 50; It works perfectly; I need a warning when the selected cells are not ...
0
votes
0answers
12 views

Excel save relative formula for re-use

I need to go through a sheet, filtering on a series of fields and running a formula against the resulting columns. However, typing the formula each time is slow and annoying. How can I save the ...
0
votes
2answers
10 views

Excel filtering all cells in column instead of those filtered

I am trying to add column value in a sheet with a filter applied. The problem I have is that Excel is adding values for rows that have been filtered out rather than just those the filter is showing. ...
0
votes
0answers
11 views

Advance Filter with multiple criteria

I have three worksheets ConditionSheet : Having conditions value in cell E5 & E7 SourceSheet : Complete Data TargetSheet : When I run macro New worksheet create with this name based on ...
0
votes
1answer
42 views

Extract multiple substrings from Excel cell

I have a horribly formatted column where each cell can contain zero or one or more entries like the following (this one contains two): ACTI-U-9754 - Some description MDCF-U-9791 - Some other ...
0
votes
1answer
11 views

Unable to remove columns based on data-type using Power Query

I am trying to automate a load process and want to know if it is possible to perform column wise operations in Excel Power Query. Specifically I want to know how to either keep or discard columns ...
0
votes
1answer
28 views

How does this SUMPRODUCT(COUNTIF( )) function work?

I was searching for a solution to count distinct values in a range, and came across this article. The example provides a list of ten names comprised of four unique entries. It then uses the ...
0
votes
1answer
12 views

Getting Excel to Auto Increment correctly

I have a question regarding Auto Incrementing when dragging formulas. I have several series of data in columns on a sheet and I am trying to reference them on another sheet. So on sheet2 I place the ...
1
vote
1answer
20 views

Centering text in an Excel formula

Is there a way to tell Excel to center the text and keep a numeric value right aligned. For example in the formula =if(+A1=+A2,"Match",+A1-A2), I would like Excel to center the word Match but right ...
0
votes
0answers
20 views

Locked cells are editable. Why?

Why am I able to edit the contents of a locked cell when the sheet is protected? What am I missing. When I select "Protect Sheet" the only choices I make available are to select locked cells or ...
-1
votes
1answer
56 views

How do I reference another cell based on the value of another cell?

No one understood my question which is understood due to my bad explanation. I'll put an example to avoid further confusion. In Sheet2 I want to change A2's formula then it will fill B2,C2, and ...