I have used a Pivot Table to create a unique list of numbers. I also have a data validation list accessing that data. Sometimes the pivot table list contains blanks. For some reason everytime I click on the data validation cell, it starts out at the bottom of the list where all the blanks are and I have to scroll to the top to pick out my options. I have chosen to "Ignore Blanks" in the data validation set up.
Why do the blanks appear at all and is there a way to get rid of them?
Good Afternoon!
Using Excel 2007 SP2, I'm looking for an automated method that will create a list of unique values based on a list I get from another source. For example this list:
1
2
4
12
qwe
985
11223344
qwe
ret
2
12
qwe
Would yield this list:
1
2
4
12
985
11223344
qwe
ret
The source data has a lot of other information I need, so I cannot simply filter uniques. I plan to copy this data into another sheet. List length will be anywhere from 1,000 to 10,000 lines long. I don't need to know how many times each value appears, I will be doing sumifs for the other data I need. I have no restrictions in terms of how this works, formulas or macros are fine
Thanks!!
Hi,
I apologise if this has been asked in the past but I have searched through quite a number of posts and cannot find my answer.
I think if I explain what my data is it might be easier to understand. Each row on my spreadsheet is a football game and I have a number of columns to show the goal scorers, so you could have the name repeated across the columns if they score more than one goal.
What I want to do is look at the cell range covering all the goal scorers (for the whole season) and bring back a list of names with the corresponding number of goals they have scored in the adjacent cell. It is the unique list I am struggling with not the number of goals.
Any help would be much appreciated.
Thank you in advance.
Hi,
I have a list of location names that may be repeated within the list. I also have possible blank cells within the list. I would like to filter them automatically into another table without having to use the autofilter or any macros to keep things simple. How could i do this by removing blank cells in the new table and having only uniquely listed names ie get rid of any duplicates.
Thanks v much!
vicky
Hi,
I have an Excel sheet containing a list of product repairs.
The list can be of warying length - depending on the product in question, and period monitored.
Each product is represented by a serial number (column A).
The can be sorted on column A from smallest to largest prior to calculating results if that helps.
The repair list contains 1 entry per spare part used, so the same serial number may occur several times.
Furthermore, a product may have been repaired on several instances - so the serial numbers can span several dates (column B).
The solution i am looking for should return the number of unique repair dates per serial number. That way i can see, how many times each product has been repaired. Results can be displayed in an individual column.
Sample list:
Serial........Repair date
20774205 2008-09-04
20775508 2008-12-17
20775521 2008-12-31
20775521 2009-01-22
20775521 2009-01-22
20775521 2009-01-22
20775521 2009-02-13
20775521 2009-07-24
20775536 2009-05-20
20775553 2009-07-16
20777012 2008-11-13
20777049 2009-03-27
20777049 2009-03-27
20777049 2009-04-03
20777068 2008-08-22
20777068 2008-08-22
20777068 2008-11-17
For instance - serial number 20775521 has been repaired on 4 unique dates.
I am a complete novice with regards to using macros/programming in Excel, so please add information about how to implement such a solution.
Can anyone help?
Good morning,
trying to find out what to do with my spreadsheet and the formulas in it.
If you look into the file 369. I can get to the stage where it outlines the mismatch figure. In the example it is 6 Mismatches.
But I cannot seem to get the table belwo right. Everytime I try and copy past the formula, the first set of data is the one from the first line and then I get a #NUM error, due to the fact that there seems to be a number reoccurence somewhere.
I took the youtube tutorial, but even copying that formula did not work.
My table consist of 2 sets of 600 values each.
Can someone tell me why I am getting this error and help me resolve the issue that the result is an existing set of data?
THANK YOU
BayerStars23
[IMG]file:///C:/Users/BINGLE%7E1/AppData/Local/Temp/moz-screenshot.png[/IMG][IMG]file:///C:/Users/BINGLE%7E1/AppData/Local/Temp/moz-screenshot-1.png[/IMG]
I am following this tutorial from youtube. It is a search function to search for a specefic word in an entire row. Here is the first part of the code:
Code:
=SEARCH(C$3,Table2[[#This Row],[DESCRIPTION]])
except i only get a value in the cell that i typed this in, instead of it searching the rest of the row like in the tutorial. i can't figure out how to fix this. anyone know what im doing wrong?
Good Day everyone
I hope the heading makes sense. Please can I get some help on the following query:
See Table:
******** ******************** ************************************************************************>
Microsoft Excel - Book1
___Running: 12.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
J5
J6
J7
J8
J9
J10
J11
J12
J13
=
B
C
D
E
F
G
H
I
J
4
Original Supplier
Supplier 1
Value
Supplier 2
Value
Supplier 3
Value
CHECK
5
A
D
10
F
11
New Supplier
6
B
G
12
F
10
H
12
New Supplier
7
C
C
11
J
20
K
15
New & Original
8
D
E
13
V
35
New Supplier
9
E
E
15
Original Only
10
A
N
21
M
12
L
10
New Supplier
11
B
B
25
A
22
New & Original
12
C
W
16
T
15
New Supplier
13
A
Y
21
A
20
New & Original
Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
What I am trying to do with the data in the table is the following:
In a separate column or on another sheet,
# where column J is = "New Supplier" - List the Unique suppliers in column C, E & G with the sum of their values.
# where column J is = "New & Original" - List the Unique suppliers in column C, E & G with the sum of their values.
# where column J is = "Original Only" - List the Unique suppliers in column C, E & G with the sum of their values.
Thank you
Any help would be appreciated.
Hello there.
First, and before all, I must admit that I am a kind a "dumb" for Excel, because I always were using it, only for better look's of simple tables, schedule's and similar. Although, I was all the time aware of great power's of this program, but newer tested it.
So, finally after few years of tempting, I decided to make a proper "order-list" for the shop in which I work. What I needed is to ,based on products and their prices, make a drop-down box, with list of the products, and after choosing one , proper price will be shown in next column. I find out how to do it with "Excel magic trick #5" on Youtube.
This is what i achieved:
http://i49.tinypic.com/dorzgn.jpg
However,
You see that in row 16, or line 2 in the order box ,we have #N/A below Cena (Price), Iznos PDV (amount of VAT), Cena sa PDV (Amount with VAT), and Iznos (Total amount). If we choose one of the product from drop-down box (now, as You can see none is chosen) and type number in Kolicina(Quantity) column, all this would be automatically changed into proper value.
But what if we have only one thing in order box, instead of 2 or all of 10 ? How to avoid those #N/A, and make instead to be blank cell, which is to be counted as 0, because of final calculation?
In this order-form we have only line 1 and 2 programed to have drop-down box in line Naziv robe (Name of the product). If I putted same drop-down boxes in rest 8 columns, #N/A would be shown in all programed cells bellow, like in line 2...
Kind regards from Serbia
Hello,
I am constructing a make-shift database in excel but can't seem to find a way to get magic trick #213 to work.
What I am trying to do is create a dynamic filter via 16 criteria. I would like any results that match all criteria that I specify and then displays results in a separate table to the right.
Thank you so much for your help - I would attach my spreadsheet to this message if I knew how.
BR,
PR
