Parsing data from one spreadsheet into another format
The data that we dump out of one machine comes in like below.
%AT_1300 Bottoms|Conductivity| (Water Out) InputRange VDC1to5
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Low 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Hi 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MinScale 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MaxScale 20.0
%AT_1300 Bottoms|Conductivity| (Water Out) EngUnits mhos
%AT_1300 Bottoms|Conductivity| (Water Out) StepResponseTime 1.0
%AT_1300 Bottoms|Conductivity| (Water Out) DigFiltTimeCnst 0.016
And I need to convert this data to this f...Counting number of X's in a column
I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get one
to work. We are using Excel 2003.
Environmental Education Association of Washington
(remove nothere from the email address if mailing direct)
"Susie Harris" <SusieHarris@discussions.microsoft.com> wrote in message
> I need to sum up the number of "Xs" in a col...Lookup based on criteria in 2 columns
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16/8 75
102 9/17/8 67
For example if I wanted to return the amount for location 102 on 9/15/8,
what formula would I use? I tried using variations of vlookups but had no
Peo Sjo...Microsoft POS #2
I have a group of customers that I am working on setting up A bundled POS
I have looked at RMS and Microsoft POS. The customer's are small bulk food
stores. They package all of the bulk food in various containers and weigh it
with a Hobart scale producing a label with an system 2 price enbedded
barcode. These are UPC A formats. They are for the most part simple single
store installs and donot require the complex RMS system.
I have setup the Microsoft POS version 2.0 and found it will work perfect
for these customers. The only problem when you programed the system you
l...Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps
crashing quite often. I cannot for example delete two messages without
outlook crashing. My colleagues do not have this problem. We are using
the Microsoft mail exhange server.
Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0,
faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0,
fault address 0x003b6e16.
Does anyone has a solution?=20
1) I would definitely apply Service Pack 2for Office 2003 + applicable
critical security updates.
2) Have you tried starting O...Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed.
If I now install roll up 2 will I have to reinstall the office 2007
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
> I already have Roll Up 1 and the Office 2007 compatibility patch installed.
> If I now install roll up 2 will I have to reinstall the office 2007
...printing multi page newsletters with publisher 2000
Created a new newsletter in publisher 2000, tried to print it on my Epson
Photo R1800 printer which supports up to 13x19 sheet paper and 13"x***' in
roll format and could not select a format to print pages 1 and 4 on one side
and then 2 and 3 on the other. Downloaded an instruction sheet from
Microsoft on printing "two 8.5-by11-inch pages per 11-by-17-inch sheet of
paper" It says on "file" click "print", choose a printer that can print on
11x17, then click "Book Printing Option" at the bottom of the dialog box.
Problem is this "Bo...how do I connect an object from one page to a different page?
I am trying to connect an object from one page to a seperate object on a
different page. The instructions say to hold down your mouse button then
click on the point you want it connected too. My problem is that is doesn't
allow you to select the starting point of the connector, then select a
different page, then click on your end point of the connector. Please help!
try using a hyperlink.
"Pepper" <Pepper@discussions.microsoft.com> wrote in message
>I am trying to connect an object from one page to...matching contents #2
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains
sequentially-sorted data which matches SOME (but not ALL) of the data
in Col A. For example.
1 1 1
2 3 2
3 4 3
4 5 4
5 6 5
6 10 6
I need to move the data in the cells in Col B next to the cells in
Col E that have the same contents. For example:
1 1 1
3 3 3
4 4 4
5 5 5
6 6 6
10 10 10
Besides dr...Linking information form one worksheet to another
Hi, i have a big problem
i want to create a link between some columns in two seperate worksheets, so
that when i type a name on the master sheet it would give me the required
information.Dont know if i explained this right, lets say on the master sheet
i have columns : Name,Sex and Height on columns A,D and BH respectively i
want that if i type a person's name in worksheet 2 it should give me the
results on columns A,C,F in that worksheet. Please help i need it asap for my
One way ..
Assuming your "master" sheet is named: Master, with data in row1 down
In Shee...Please ignore #2
Testing a posting problem
...outputting values to a range from one formula
I wish to generate a table automatically by means of a single
formula that applies an iteration on a starting given value with
a given step, and the computed values are posted/entered
automtically into cells from a given cell onwards, say below
it, until the computed value reaches a certain given limt.
This is somehow the inverse of INDIRECT or of OFFSET. These
can pull values from a variable addresses of cells. What I need
is to push values into a variable addresses of cells.
Can anyone help me on that??
---------------------------------------------------------...DVD off Center and Right side cut off in WMP 11
I am using Windows XP Pro SP3 and just updated to WMP 11. When I play a DVD
it seems to be zoomed in or stretched on the screen and the right side of the
movie is cut off. I've tried everything I know to do to fix it, and that
knowledge is slim! Any suggestions are very much appreciated!
...Outlook freezes after sending one email after upgrading 4.0
We just upgraded from 3.0 to 4.0 this weekend. All client machines have had
the desktop client upgraded and 2 have the same issue. One is XP with Outlook
2003 and the other is Vista with Outlook 2007. Open opens and the CRM addin
initializes correctly. As soon as you compose and send an email, Outlook
locks up and you have to kill the process in task manager to close Outlook.
I've had the same problem and have tried all I can think of...how did you fix
> We just upgraded from 3.0 to 4.0 this weekend. All client machines have...2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ?
We have a small store and would like to setup a second register as a backup,
temporary addition ( during rush hours)
Since we are a small show i do not need to have a separate register reports.
Can two registers ring up all sales together as one ?
How can i set this up ?
No, you can't do that.
You might be able to use the Register Analysis report available in SO
Manager Utilities/Crystal Reports to get something close to a single Z
Tiber Creek Consulting
How do I print white text onto black paper? The text just comes out blank
when printed. I am using a black background on screen to see what it looks
like, then deleting that so I can print in white.
On Mon, 12 May 2008 18:46:03 -0700, PJ1980
>How do I print white text onto black paper? The text just comes out blank
>when printed. I am using a black background on screen to see what it looks
>like, then deleting that so I can print in white.
Does your printer have a WHITE ink cartridge?
You can't do it.
Ther...reason codes #2
I'm having a big problem tracking discounts in RMS. Whenever something is
discounted up front, a reason code is set. There are several I use for
However, when I try to do an Item Movement History report and select based
on those reason codes, I never get any matches. When I do an item history
report for a few weeks, I notice that the only reason codes that are
displayed are the ones pertaining to inventory adjustment. It seems that
reason codes associated with discounts do not display in this report.
HELP! I need these to display to track discounts (and also store use)!
...HELP in printing A3 size newsletter-magazine which has a centerfold.
hi! i want to print a newsletter magazine in A3 size. so that means, the
newsletter must have a paper size of H:17" and L:11". When i set the paper
size in mspublisher to A3 portrait, the centerfold expands to h:22"....
which consists of two A3 size papers.... how can i correct this so that
each page will print like two short bond papers combined in the middle?
also, how can i set mspublisher to print without borders? in my printer
setup, there is a borderless settings. problem is, if i select that, some of
the layout will be cropped out in the borderline.... so it look...Outlook Express 5 #2
On loading, error message "MSIMN caused an invalid page
fault in module DIRECTDB.dll at 017f:7dbf3070.." Appeared
to coincide with display config change?
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tip of...CRM 1.2 12-02-05
I have installed MS CRM 1.2 on a SBS 2003 server. Problem is I can only start
the application if I log onto the server usind the server administrator
account. If I try to access using a domain users account I just get a page
cannot be displayed error, could somebody please help...
Have you added the appropriate domain users as crm users using the
"Redders" <Redders@discussions.microsoft.com> wrote in message
> I have installed MS CRM 1.2 on a SBS 2003 server. Problem is I can only
>...Workbook_Open Help #2
Here's the code
Private Sub Workbook_Open()
Call Unhide_Sheets '
Fable's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=218
View this thread: http://www.excelforum.com/showthread.php?threadid=26252
and there's no application.screenupdating=false statement in your
"Fable" <Fable.1d07w...Sum column values that contains text &/or dates
Column D3 thru D43 contain a mixture of values & dates. For example:
D3 = 16,026.76
D4 = 11-18-05
D5 = blank
D6 = 6,855.34
D8 = blank
D9 = 5,270.00
D10 = 11-02-05
Need sum to equal 28,152.10 (total only values from entry or formulas)
Thanks so much. mikeburg
mikeburg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24581
View this thread: http://www.excelforum.com/showthread.php?threadid=489114
If your dates are text strings which say "11-18-05"...Shared services admin page missing
PS2007 SP2 FebCU and WSS 3.0 SP2 FebCU
Installed PS2007 and migrated data on a new dev server with win2k8.
Everything is running good and i even got through the migration. However, i
cannot build cubes. The error says that it cannot connect to the analysis
service Db, then below that is says "provider cannot be found..."
I used the technet guide in addition to MSProjectExperts Implementing and
Administering MOPS2007 to retrace my steps and it appears that I've not
missed any steps.
I then noticed that my SharePoint Services Provider admin site is no longer
a...Create two rows based on one row
A worksheet has information in a single row. The new worksheet has columns. How can I create two rows per column in this new worksheet, based on information from the single row (key=document number, same amount for debit- and credit - but in a different row, accounts based on table) .
not really sure about your spreadsheet layout. Could you post an
example (plain text - no attachment please) and describe your expected
result based on this example
> A worksheet has information in a single row. The new worksheet has
> columns. ...bar chart on 2 axis
I am trying to create a bar chart. I have 9 series for which each have 2 sets
of data value. I want to create a bar chart where each series is represented
by 1 bar, with the chart having one set of values along the x axis and one
along the y axis. I am having great difficulty with this. Can you help at all?
Full instructions are found at
Bernard V Liengme
remove caps from email
"Hannah" <Hannah@discussions.microsoft.com> wrote in message