**0**

votes

**0**answers

5 views

### Excel or Access? Analysing large data set

I have been reading suggestions whether to use excel or access- but can't seem to find a solution.
I am aware that Excel is best with number and analysis, and Access is best for storing large data.
...

**0**

votes

**0**answers

5 views

### Copying data from an entire column in excel worksheet into another worksheet minus blank cells

Instead of using a copy and paste function is there a way to lookup data in an entire Column rather than an individual cell in one spreadsheet and list it in another ( minus the blank cells )so it ...

**1**

vote

**1**answer

10 views

### Searching for Re-occurances in EXCEL and using those Re-occurances

I am trying to create a function that looks to see if the value of a field, lets say "A1", occurs elsewhere in the "A" column, and then searches the rows of those re-occurances and if any of those ...

**-3**

votes

**1**answer

10 views

### I need some help in excel validation

I'm not good in excel. I need to include an excel sheet in my page, and I need an expert who can write these custom formulas for cells validation.
1) A column that accepts only letters, no numbers or ...

**-2**

votes

**0**answers

8 views

### formulate and copy the data in another sheet

i would like to enter students name in Sheet 1.
sheet 2 contains age category like 6-7//sheet 3==> 7-8 and son on.....
Data to be entered will be...
Sheet 1==>Column A==>Students Name//column C==> ...

**0**

votes

**1**answer

16 views

### Excel : Counting multiple word that available in sentences and multiple rows. (countif, search)

here is screenshot for the sheet.
https://flic.kr/p/qZb8ot
in column A there are some senteces list below:
A2. T-shirts, Varsity
A3. T-shirts, Sticker, Mug
A4. T-shirts
A5. T-shirts, Pin, ...

**2**

votes

**1**answer

36 views

### What would be the the mathematical equivalent of this excel formula? =PMT()

I need to create a javascript form that does the same calculation as this =PMT() function.
mortgage = 220000
rate= 4.75%
term = 30
The example formula I have is =PMT(4.75%/12,30*12,220000*-1)
What ...

**1**

vote

**0**answers

10 views

### Lookup value based on part of a cell

In Excel, I have a list of tasks (column A) , with one master ID number (Column B)
This master project number is a combination of text and numbers in format ABC.001
I have another list of sub tasks, ...

**0**

votes

**0**answers

5 views

### SUM spread across a series of cells unevenly starting with 0

I have a SUM, let's say it's 5000 users over a 12 months of growth. How do i show this is a series of cells where we start the monthly users at 0 per month and each the new subscribers and end at a ...

**0**

votes

**1**answer

17 views

### How do I get URLs from hyperlinks in Excel 2010?

I have a column of cells with hyperlinks (to web addresses) and I need their URLs to be regular text. Is there a way to extract the URLs from hyperlinks?
Example:
Cell says: "CLICKME"
Links to: ...

**0**

votes

**1**answer

17 views

### Intersect ERROR:Method 'Range' of object '_Global' failed

Why A get this error: Method 'Range' of object '_Global' failed When I Put:
Private Sub Workbook_SheetChange(ByVal WS As Object, ByVal Target As Range)
Dim NTT As Range
Set WS = ActiveSheet
Set NTT = ...

**1**

vote

**2**answers

15 views

### excel: export csv file with japanese character

In my excel file, the Japanese character is shown correctly,
while when I export it as csv,
the character become question marks
How should I output so that the character can be shown correctly?

**3**

votes

**1**answer

23 views

### Excel formula to get first and last non-empty value in a row and return column header

Let's say I have an Excel spreadsheet aggregating votes in some poll over a period of time as per the example below.
How do I find the min and max value people have voted on on a given day (the ...

**0**

votes

**1**answer

12 views

### Excel 2013 global automatic macros

I am trying to log the opening and closing of excel workbooks to replace the Journaling capability in office.
I have created and tested VBA auto_open and auto_close macros in excel, which log these ...

**0**

votes

**1**answer

37 views

### How do I display name in column2 dependent on value in column1?

I am doing an inventory for all the businesses of a street. I have a two sheets, where on one I have different categories for commercial uses.
Each category displayed in sheet 1 has a number (1 to ...

**1**

vote

**0**answers

13 views

### Build comprehensive formula for all precedent cells

Is it possible to build a comprehensive formula for all precedent cells? I'm aware and employ the "Trace Precedents" and "Trace Dependents" feature in Excel often, but this only goes back one "layer" ...

**0**

votes

**2**answers

12 views

### Reformat vertical data to horizontal (side-by-side)

I have a spreadsheet containing groups of data in a vertical format, e.g. here are three "groups", each with five rows:-
I would like to reformat the spreadsheet so the values are all side-by-side, ...

**1**

vote

**0**answers

14 views

### Select elements in an array that satisfy a criteria

The goal: Kappa-Sigma clipping in Excel
I want to implement a selective linear regression formula in Excel (avoiding VBA). I have a data sample on which I need to apply a linear regression. But my ...

**-3**

votes

**0**answers

15 views

### Annual Salary increment for selective staff in EXCEL 2007 [on hold]

Annual Salary increment for selective staff in EXCEL 2007
emp no 100 200 300 400 500 Amount
95 x (want the amount to here when I put "x" next to any empl)
1984 x
2659 ...

**3**

votes

**1**answer

10 views

### Why can't I use a number wildcard to in Cells.Find in VBA?

I'm trying to search my Excel worksheet for any cell that has a value that begins with a number followed by a period, but this isn't working. Does anyone know why not?
Cells.Find(What:="[0-9].", ...

**1**

vote

**1**answer

26 views

### Excel formula related to if statement

I need a formula which satisfy the following condition:
If A1="Yes", then the corresponding cells B1, C1, D1......etc should contain the word "yes"
IfB1="no", then the C1 should be "no" such that the ...

**2**

votes

**1**answer

6 views

### Restrict paste into dropdown cells in excel

I have one excel sheet which contains many dropdown columns. Lets say one column has Test1, Test2, and Test3 as dropdown option values. Cells under this column should not accept the values other than ...

**0**

votes

**1**answer

11 views

### VBA Code for changing background text for any text within a cell

I'm trying to make a row change colour to yellow based on if any text is within the D column. I have already set up 5 different colours for another cell, however need this to over-ride those ones. I ...

**1**

vote

**0**answers

25 views

### Count non-blank values after a cartesian product in excel

I hope my description is accurate; improvements welcome.
I have 2 tables in Excel.
In Table1 there are 2 columns, A and B. It can be a many to many relationship.
In Table2 there are 2 columns, A and ...

**0**

votes

**1**answer

19 views

### Placement of Secondary Horizontal Axis

On the primary horizontal axis I can go to Format Axis > Line Color and Style. There I can choose the color and style of the line that represents 0 on the primary vertical axis.
However, with the ...

**0**

votes

**1**answer

18 views

### Excel VBA: Intersect methode with several names range [on hold]

The Intersect don't work.
Dim NTit As Range
Dim NInf As Range
Dim NDat As Range
Dim WS As Worksheet
Set WS = ActiveSheet
Set NTit = WS.Range("$A$1:$J$1")
Set NInf = ...

**0**

votes

**1**answer

13 views

### Publishing an Excel Spreadsheet Online

I'm working with a client that uses very sophisticated excel spreadsheets for generating purchase orders. They would like to place these online so a dealer could use it to submit a purchase order on ...

**-3**

votes

**1**answer

22 views

### Removing a column of hundreds of bad addresses from the main address column [on hold]

How do I remove a column of hundreds of bad addresses from the main address column? Do I have to find/delete each address individually?

**0**

votes

**0**answers

40 views

### Daily Calculation Average [on hold]

I have a calculator that I created for my teammates. The calculator asks for 3 pieces of data that outputs 1 piece of data.
The output is then copy and pasted into a daily tracker by the user.
The ...

**1**

vote

**1**answer

23 views

### Select Cells in Column Up to End of Data in Adjacent Column on OSX

I know there is a command to do this but I just can't find it. The answer here should have used this command but did not.
Q: Given an empty column (B) adjacent to a column populated with data (A). ...

**0**

votes

**1**answer

39 views

### Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only? [on hold]

Countless times a day, I go into Windows Explorer, shift-right click on an Excel file, Copy as path, then go into Run, type Excel /r (paste), which opens my Excel file as read only.
Is there a way to ...

**0**

votes

**0**answers

17 views

### Spreadsheet finding and sorting most frequent appearance of names

I have a spreadsheet that looks like the following:
https://docs.google.com/spreadsheets/d/1BN3GNRFCsBeHu9gQaKzIo7bfFRkcDqMJ6VMtidEwPD4/edit?usp=sharing
There is a set list of names in Column A. ...

**-1**

votes

**0**answers

24 views

### Excel: sumif, index/match: reached the end of my ability

Im sorry to come begging for help and i have been all over the palce trying to find a way around this.
I have tried all sorts and also done a lot of searching on the interweb... what I have vound is ...

**0**

votes

**2**answers

19 views

### Array formula, slowly work on Excel [on hold]

Does the array formula make excel to run slowly? i'm talking about a range that contain 1000 raws and 10 columns.

**-1**

votes

**0**answers

16 views

### Excel- How to use lookup formulas to look up on part of the content of a cell [on hold]

I created a table with a searchable drop down list that gives you all the prerequisites for the class you choose from the drop down list. I chained it so that it gives you up to five prerequisites ...

**0**

votes

**1**answer

11 views

### cumulative profit of each client in table no 2 from data of table 1

I want cumulative profit of each client in table no 2 from data of table 1
formula i use is ...

**0**

votes

**1**answer

14 views

### Where to put the Change Event Code

CHANGE EVENT: I have 12 sheets in a workbook. Do you have to put the Change Event in the 12 sheet, if not, where I must put the code for this event.

**0**

votes

**0**answers

18 views

### Formula to search two columns of a database and return value from different cell in the matching row

I am designing a spreadsheet for scheduling appointments. On one sheet I have all the data but the dates and times are not in chronological order. I am having trouble writing a formula that will ...

**0**

votes

**0**answers

36 views

### Sort column elements in reverse order by row ID [on hold]

I have a column of numbers in Excel:
column A
row ----------
1 2.11
2 1.123
3 2.222
4 ...
5 ...
6 ...
What I want to do is sort those in reverse order by row number (not by ...

**0**

votes

**2**answers

35 views

### import text file into excel

I have a text file that has the following text content:
County Name: test county
Athlete ID Count: 280
Activity Count: 574
Average Distance: 35255
...

**0**

votes

**1**answer

28 views

### Duration calculation in seconds [on hold]

This is what my data looks like. How do I calculate the duration, in seconds. I've tried some an answer but it looks complicated -
=INT(E226-D226)&" days "&TEXT(MOD(E226-D226,1),"hh "" hours ...

**-1**

votes

**1**answer

22 views

### Merge Two Dynamic Tables in One Table [on hold]

I have try to merge/combine two tables but I have always fail.
How can I merge/combine two dynamic tables in one table

**0**

votes

**0**answers

23 views

### Excel timeline summing overlapping values [on hold]

I have an excel spreadsheet with the following values:
Start End Value
1/12/15 5/12/15 6
3/10/15 4/8/15 3
I want a timeline that starts at the earliest date out of the entire ...

**0**

votes

**1**answer

20 views

### Filter data for different data serie to display in XY-Plot

I want to paste the date (see image) in my excel sheet a get a XY-Plot with 4 data series, one for each Method
Until now I filter them by Method and copy each result, so I get 4 tables for 4 data ...

**0**

votes

**1**answer

35 views

### Excel combination 6 [on hold]

Good morning,
I am trying to do in excel all possible combination of 1 to 6 without repeating.
6!
How can I list the 720 possibilities
Thank you,
examples
123456
132456
654321

**0**

votes

**0**answers

19 views

### Excel cell value showing when printed despite font colour and fill colour being exactly the same

In Excel, if I set the fill colour and font colour of a cell to be Gray (RGB 217-217-217) and then type "TEST" in the cell, I cannot see any text but when I print it (I made the cell significantly ...

**0**

votes

**0**answers

12 views

### How to open an excel and prevent the automatice convert the numeric fields larger than 15char

We work with a software that we must export data from and use this information for multiple functions, one is the data is reopened in Excel. Excel converts the numeric fields greater than 15 char to ...

**0**

votes

**1**answer

33 views

### Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets
Sheet 1 contains 2 columns.
Column A has a range of unique alphanumeric identifiers.
Column B has a range of non-unique numbers.
A B
...

**0**

votes

**0**answers

9 views

### Information into multiple sheets

I run a drag racing promotion company and need some help in creating a workbook for shows. I want to put a master list of names in sheet 1, sheet 2 through 20 will be the different classes. Is there ...

**-1**

votes

**1**answer

14 views

### Creating a button linked to tex and not cell [on hold]

I want to create a button in Excel that is linked only to a word, so that if lines are removed, the button is still linked to the text and not the cell. How can this be done?