**0**

votes

**0**answers

13 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

**1**answer

13 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

11 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

11 views

### Replacement of a string in excel with another string, taken from a csv file

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

16 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

**0**answers

16 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

17 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

15 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

20 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

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

**1**

vote

**1**answer

20 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

17 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

7 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

21 views

**1**

vote

**4**answers

44 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

34 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

19 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

305 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

19 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

14 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

27 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

25 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

15 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

20 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

35 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

8 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

19 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

16 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

41 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

10 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

27 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

19 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

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

**1**

vote

**2**answers

30 views

### How to use OR in a COUNTIF function when dealing with dates and “>” characters

I want to write a function whereby I could count a cell if it is blank OR greater than a date.
This is a piece in what will be a much larger formula so looking to avoid a solution of ...

**-1**

votes

**1**answer

42 views

### Formatting any cell referenced in a Formula

I have two sheets, one with formulas pulling data from the second. I need to create a macro or some conditional format to highlight the cell green if the data was pulled from the second sheet. sheet ...

**0**

votes

**0**answers

34 views

### multiple IF conditions and answers

This is a cashflow spreadsheet. I want the column next to the expenses column to show me the source of the expense.
The expenses are arranged in spreadsheets, so for example; checks, taxes, general ...

**0**

votes

**1**answer

28 views

### Can PivotTable create Pareto buckets?

Is there a way to use a pivot table to create cumulative buckets or brackets...from either built in functionality or a back-door method? My analysis is to show aggregate data for items that comprise ...

**2**

votes

**0**answers

15 views

### Fill one Word Form and Get Several Different Docs Filled with same information

In my word form there are spaces for name, surname etc. I also have some other documents that have similar spaces for similar things. Every time when there is a new case, I have to fill the form, fill ...

**0**

votes

**1**answer

20 views

### Excel help, formula for one cell looking at information in another

Excel, How do I get one cell to come up with "N/A" when "No" is selected from another cells drop down?

**0**

votes

**0**answers

15 views

### Sorting and separating by category in creating a macros

I have spreadsheet with products by code, description, unit and category.
i want to create a macro that will sort by
category
description
then have 2 rows between separate categories
place the the ...