**2**

votes

**1**answer

14 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

**0**answers

10 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

**0**answers

10 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

**1**answer

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

**0**answers

17 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

**0**answers

22 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

**1**answer

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

**-1**

votes

**1**answer

40 views

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

How can I create a formula for the following spread heet?
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 give me total number ...

**0**

votes

**1**answer

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

**0**answers

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

**0**answers

18 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

**1**answer

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

**1**answer

21 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

**0**answers

25 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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

26 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

**1**answer

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

**0**answers

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

**1**answer

27 views

**1**

vote

**4**answers

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

**2**answers

39 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

**1**answer

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

**1**answer

24 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

**2**answers

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

**0**answers

25 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

**1**answer

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

**2**answers

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

**2**answers

27 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

**3**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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