Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serach for numbers starting with for example 49****???
Hi all,
i have a small problem. And it follows like this: I create a new workbook, wich will contain a couple of charts based upon data from 10 other workbooks. I need to search two columns for 2 things. one should search for a month, and then count all numbers in the other column, within that month wich starts with 49!! Example: A b 4900 Jan 3800 Jan 4901 Feb 4911 Feb 2000 Feb So the code should in this case display: Jan Feb 1 2 How do I this??? Would appreciate any help, Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serach for numbers starting with for example 49****???
Hi Daniel,
first you need to create a table that contains the data you really need. In your case add column c with the formula =left(a2, 2) which will give you 49, 38, 49.... Then you make out of your table a Pivot-Table with colum c in rows, colum b in columns and number of records (any columns from a, b, c you like) as the value. you'll get a table like this: jan feb 38 1 1 49 3 2 etc. You can then make some finetuning: - show in column c only what you want to see, or - hide unwanted data in the pivot table. regards arno |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serach for numbers starting with for example 49****???
Thanks, it solved the whole thing!!!
Daniel Karlsson *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
serach of dat | Excel Discussion (Misc queries) | |||
numbers starting with 0 | Excel Worksheet Functions | |||
Store numbers starting with zero as 2 digit numbers | Excel Discussion (Misc queries) | |||
How do I quadruple numbers starting with 1, 2? | Excel Discussion (Misc queries) | |||
how can i move the starting point for the numbers numbers down. | Setting up and Configuration of Excel |