Macro or Formula needed to search data in cells
I am looking for a way to create a formula/macro to do the following:
My worksheet setup:
01 02 03 04 05 06 07 08 09 10 01 04 05 06 08 09 12 22 23 27
02 03 04 05 06 07 08 09 10 11 01 03 05 06 07 08 09 14 22 32
03 04 05 06 07 08 09 10 11 12
04 05 06 07 08 09 10 11 12 13
Each cell contains a 10 number sequence. The range A1:A30000 is my
randomly generated sequence. And C1:5000 is my database of archived
If I wish to check if the combination in cell A1 is anywhere in the
range C1:5000. I use the formula.
=IF(COU...Dynamic Bar of Pie Chart: Series1 Label & Value Issue
I have created a Bar of Pie chart and everything works great. I even have
named ranges on my data so that the bar portion automatically updates when
the data changes. However the Series1 Label on the pie itself does not
change to reflect the new total so that it is the sum of all the values in
the right column below. Does that make sense?
I have one series and my data looks like this:
The pie portion has Contracts & Other as labels with the totals of...New window behavior?
It seems the Excel folks are always striving to find some way to make Excel
behave differently from all other Windows applications in some regard. The
most glaring example, of course, is cut, copy, and paste, but I just
accidentally discovered another one, and I'm wondering how long (i.e., since
what version) Excel has been doing this.
I'm using Excel 2003, and when I right-click on a child window's window
menu* I get a context menu with things live save, print, new window, etc. I
tried this in Access and Word and right-clicking a child window window menu
does...absolutely nothing...Search for data in a column bring all related items in other colum
I have data in the excel sheet with .A column for OrderNo and B Column for
for that Order.
There are more than thousand orders.I want search for an Order so that it
brings all items with it.
I cannot use filter in A column as it doesn't recognise blank cell.So Option
repeat order nos in A for every item involves a lot of data entry.
Any Solution ?
I'd fill those empty cells in column a with the previous value. And us...how do I get more than 19 bars on a bar chart
Hi! I have three columns of data each containing 84 entries. These are
grouped in threes, and I wish to create a bar chart to show the comparison
between groups A, B and C.
I use the chart wizard, create a bar chart, then create the series. Then
for each series I go down the column with CTRL held down, selecting each
third entry. This is fine for 19 entries, but when I click to select entry
no. 20, the series clears itself. If I highlight 20 entries and then click
on Insert/chart, I get the message 'Series formula is too long'.
Can anyone explain please how to over come t...Updating information in 1 file when it is added to other files
I have 9 Spreadsheets consisting of contact information for publications in
different industries. 8 Industries and 1 Master List. I would like to link
the master list to all of the individual industry lists so that when I add or
update a new contact in an Industry list, it is reflected in the Master
Spreadsheet as well. Essentially, I want to cut down on duplicating my
Check out the copy paste merge examples...
> I have 9 Spreadsheets consisting of contact information f...How to insert an existing macro into "Additional Include Directories"?
I have post this to another group. To avoid cross posting, I give the
link to the original post.
Please give some consideration. Thanks in advance.
...Why does linked data from blank cells become a zero?
When linking data within the same workbook (to different tabs) any cell that
is empty - shows up in the new tab as a ZERO (0).....what am I doing wrong? I
want those cells to remain blank.
That's just the way it is ..
Instead of : =Sheet2!A1
you could use an error trap: =IF(Sheet2!A1="","",Sheet2!A1)
Alternatively, we could suppress the display of extraneous zeros
in the entire sheet via:
Click Tools > Options > View tab > Uncheck "Zero values" > OK
GMT+8, 1� 22' N 103� 45' E
xdemechanik <at>yahoo<dot&g...Date chart formula question?!?1
In a very old spread sheet i was using this formula
=IF(OR(AND($D7<G$6,$E7>F$6),AND(F$6>=$D7,F$6<=$E7)),".","") and it worked for
dates pre 2009. However, i now wish to use it for dates between 2010 - 2011.
Each column represent a week and the rows will indicate and project or task.
can anyone help?
There is nothing it that formula that will make it work for pre-2009 and not
for later years.
Perhaps you need to look at your data values?
If you have a problem, you could tell us what values are being fed into the
formula when it works...public calendar- users can only view items they added????
hi lovely people,
i'm trying to get my head round creating a public calendar, a year planner
for the business with our small 1 server domain. we just got sbs 2003 after
many years of a decrepid nt4 thing, its quite a culture shock!!!
anyways here is my question...
i've created a public folder calendar. i did this through outlook 2003 in my
i added numerous events to this public calendar fine and dandy from the
now, i can add to and view this public calendar quite happily.
my problem is, i can add this new public calendar to any other user ac...How change dimensions of data label text box in pie chart?
In Excel 2003, I can't seem to re-shape the data labels text boxes in my pie
chart. I can change the font and allignment of the text within the text box.
But, if the text defaults onto two or three lines, I cannot stretch the text
box out to get the text to stay on one line. Normally, you can pull on the
the little handles on the text box. Is there a trick to this that I don't
This is a deficiency in Excel's charting capabilities. The text elements
seem like regular text boxes, but you are unable to resize or reshape
them. Even VBA can't do this.
The workar...Getting data point from an accel chart
I have an excel chart that I want to get the data points(x,y) from.
The source data refers to cells in the same sheet, but I don't see any cell
in that work sheet. Only the chart.
I can run the cursor over the line and get the x,y coordinates for each point.
I would like to copy the x,y values, to reproduce the curve in another program
...Area, perimeter, and color in shape data
I have Visio Professional 2007.
First, I don't have great skill yet in making shape data. But also, I
would like to have the following data show in the shape data for various
geometrical shapes (like squares, rectangle, or circles, for example):
- the area of the shape
- the perimeter of the shape
- the color of the shape
Now, I understand that I can go to Tools > Add-Ons > Visio Extras >
Shape Area and Perimeter to get the first two items. I also know that
this information will change dynamically as I alter the shape. So far,
...Trying to automatically import specific data from Excel into Word:
Thanks in advance for anyone who can help me with this:
I'll start by explaining the spreadsheet I created in Excel (an inventory /
It is pretty simple; approximately 12 columns. The key column is the item
number / UPC / bar code number, then after that there are various information
columns including item name, description, condition, picture links, etc.
Secondly, I created a template Microsoft Word document that is relatively
long, but will have a few lines (give or take...about 7) customized for each
item on the inventory.
What I am trying to d...Filtering Excel 2003 Charts to a date range
I have multiple charts that we look for trends on over 1-2 year time frames.
Is it possible to have a chart show all the data that has been entered and
when looking at the chart have a date range data to format that range
differently. What I am trying to do is we have weekly or montly meetings, in
these meetings I would like to show all the additional data differently that
has been added since our last meeting, while showing accumulative data in a
The easiest way to get different formats is to use different series. If you
had one series, you could use autofiltering to...ADDITIONAL INFO RE: Data execution prevention
Since my last post, I have some additional info that might help someone
get an insight as to what the problem may actually be.
First, I went to start/run and put in "sfc /scannow", and let it run
fully. Everything copacetic there. The I checked Admin. tools for the
read-out. Under the "Error" heading was this info:
Faulting Application rundll32.exe version 5.1.2600.5512, faulting module
unknown, version 0.0.0.0. fault address0x00000000
Clicking on the "Online Help" link brought up a blank page - no help.
Hoping some terrifically insightful MV...CRM Integration: data doesn't go from CRM to GP
I'm setting up CRM integration for GP. Setup went ok, data migration from GP
to CRM ok. When I add data to GP, it copies to CRM ok.
I can't seem to get any CRM data to copy to GP. No messages in event viewer.
Services are all started (according to documentation) successfully. I'm
pretty sure I've configured properly in Settings and Admin tool. My
IntegrationUser account is a member of all the required groups. I've turned
on 'create customers always' to test, so I should create customers in GP
whenever I create an account in CRM, but that's not happe...Data was deleted and saved by mistake..need to go back
I need to go back to the data before it was saved, can
don't get your hopes up. Unless you have a copy or a backup ... it's gone.
"Richard" <email@example.com> wrote in message
> I need to go back to the data before it was saved, can
> anyone help
...Hide one month in a chart
I have data from July 2006 to January 2007 that I need to chart. The
only catch is that there is no data for Dec 06 (we do not capture this
data due to the Xmas rush).
On the chart I would like to remove Dec 06 but have not succeeded. Any
In the cell where the Dec 6 data should go type =NA()
This will display as #N/A
Excel will ignore it when it charts
But Dec 6 will still be on the x-axis (it would be misleading to not have
Bernard V Liengme
remove caps from email
<firstname.lastname@example.org> wrote in message
news:1170456927...Perserving secondary axis in pivot chart
I have a Pivot Chart with two series of data, one of which is plotted on the
secondary y axis. Every time I refresh the chart, it defaults back and I
lose my secondary axis. I then have to manually change this every time.
This is a know issue.
XL2000: Changing a PivotChart Removes Series Formatting
> I have a Pivot Chart with two series of data, one of which is plotted on the
> secondary y axis. Every time I refresh the chart, it defaults back and I
> lose my secondary axis. I then...moving favorites from my old Internet Explorer to a new computers
I am trying to move my favorties (links) from my old computer which was
Internet Explorer Windows XP to my new computer which is Internet Explorer
What ever I try does not work.
Is this related to Microsoft Outlook somehow?
Using IE, click on File > Export/Import and export your bookmarks to a
location like your desktop where you can easily find them. Then copy them
onto disk and move them over. Copy them from disk to your new PC, open IE,
and import them.
"Paul B" <PaulB@discussions.microsoft.com> wrote in me...Issue in reading data from Excel
I have 3 excel files with me. say,Test.xlsx, saved.xls and
Here Test.xlsx has got reference to saved.xls and original.xls and
displays values from both files. But the cells referring to data from
Original.xls shows #N/A in Test.xlsx where as data from Saved.xls
shows the correct values. (I am using the formula: =HLOOKUP(A5,'D:
Here, saved.xls and original.xls has got same columns and same data,
but if i check the files size of both, they are different.
size of Saved.xls is 26 KB and the size of Original.xls file...How to remove newly added server from site?
setup: exchange 2k3, enterprise (backend-frontend).
We recently added a member server for testing purposes, without assigning
any roles, just a clean install of exchange+SP1. After some days incoming
emails from internet got stuck in local delivery queue on that new server.
figured out that this new server was first in the msExchOwningPFTreeBL, thus
all emails to public folders are sent to this server instead of our primary
one. the new server does not have the hierarchy (replication and/or "send
hierarchy" do not work and no error message appears in the logs) and
therefo...Line Series Color on Graph
Is there a way to make a line series on a line graph change colors based on
the value of another line? I have a line graph that has 2 lines. 1 green
line representing Total Expenses and 1 line representing Total Revenue. I
would like the line representing Total Revenue to be red whenever it is below
the line representing Total Expenses and then change to blue whenever it goes
above the Total Expenses line. Is this possible?
Check out Jon's page on conditional chart formatting:
*Remem...Transfer data from Excel col. A to columns B-E in the same sheet
I have an Excel 2003 spreadsheet with only one column of player data: column
A. The first three data items in column A are the same for every player:
Name, Address and Phone. Every player also has at least one comment but
could have any number of comments. Each player’s data is separated from the
next by a blank cell in column A. Sometimes, a player’s last few comments are
blank resulting in multiple blank cells in column A before the data for the
next player starts.
I need help writing an Excel 2003 VBA macro to:
1. Copy just the player’s name, but not the Name: label, to c...