splitting one column into two columns ... not what you think
i have fixed column widths that can't be changed; nor can any other columns
be added to the worksheet ...
i've got data in one column that represents "results" ... within the results
column though, i need two columns (starting directly below the "results"
cell, one that reads "in range" and that other that reads "out of range" ...
if i'm on [column a] [cell 1] i want: "results" ... in [column a] [cell 2] i
want: "in range" AND "out of range" with a line down the middle. "text to
column" is ...Disaster Recovery for CRM 1.2
Does anyone have any documentation on the steps to backing up CRM 1.2? We
want to make sure we are backing CRM 1.2 up correctly if the server should go
down. We were unable to find any documentation on Microsofts website for a
step by step backup solution. Right now we are just backing the CRM
databases using the scheduler in SQL; is this ALL that is required and if so
do we backup ALL of the databases or just certain ones?
The owners of the company want to make sure we can restore ALL of the data
Microsoft have included details of backing...Finding duplicates in column
I have Excel 2002 and have 6000 emails addresses in a column.
How can I find if there are any duplicates in that column?
Assuming the data is in column A, add a formula in column B of
Cpy that down, then you can filter column B for Duplicate
Sorry to be so newby Bob, but when you say 'copy' down, what exactly do
I have entered the formula in B1 but..
Bob Phillips wrote:
> Assuming the data is in column A, add a formula in column B of
> =IF(COUNTI...Outlook 2003 forgets contacts after 1 day
Outlook 2003 is remembering contacts for a day and then automatically
deleting them. I have spent the last hour searching and can't find the right
setting to stop this from happening. Has anyone got any advice?
Outlook does not automatically save Contacts ever. To what feature are you
"slycbod" <firstname.lastname@example.org> wrote in message
> Outlook 2003 is remembering contacts for a day and then automatically
> deleting them. I have spent th...Summing distinct rows in same cell
Sorry for the bad title I'm not sure hte best way to sum up this issue.
Fruit Price Total
Apples 0.69 40
Bananas 0.34 38
Lemons 0.55 15
Oranges 0.25 25
Apples 0.5 10
Pears 0.59 40
Almonds 2.8 10
Cashews 3.55 16
Peanuts 1.25 20
Walnuts 1.75 12
Apples 0.5 5
Given the data above I'm trying to sum the totals for only the Appl
rows. So basically I need to search the Fruit column find the row
that have "Apples" and then sum their corresponding Totals, giving m
55. I've been playing with this for hours with Lookups and Indexes bu
am not really getting anywhere. Also, I can...How can I choose alternate rows in a column?
My requirement is to be able to create a column whose elements consist of
difference between adjacent elements in a column, say column A. If I can
choose alternate elements and create 2 new columns then I can just subtract
the 2 columns easily.
"pnair" <email@example.com> wrote in message
> My requirement is to be able to create a column whose elements consist of
> difference between adjacent elements in a column, say column A. If I can
> choose alternate elements and create 2 new colum...Assign values for one column to another.
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
and copy down.
Hope this helps.
On Oct 14, 4:26=A0pm, Celticshadow
I have a Year-at-a-Glance worksheet into which users enter important dates
and associated actions to be taken. I now want to use Conditional
Formatting to highlight specific entries in the worksheet when their date
matches today's date.
The problem I have is that I need to convert data from three independent
cells into a date to compare it with 'TODAY()'.
The first cell (formatted as a number) carries the day, e.g. 2, 17, 23,
The second cell (formatted as General) carries the month, e.g. January,
March, September, etc.
The third cell (formatted as a num...Column styles doesn't appear on the worksheet
one of my customers has changed the windows xp designs to its own. From this
moment excel doesn't show the font color and the background color of a cell
in the worksheet. Only in the print preview you can see the color settings of
I'm not shure if this problem belongs to the changing of the windows xp
designs, but from this moment it did occur.
This occurs on new excel-documents and on existing ones. With another user
account on the same machine the problem doesn't occur.
I have reinstalled Office 2003 and even deleted user registry entries for
Office...IF / SUM
I have a spreadsheet with 17 rows, each representing a project name. In
the columns, I have 2 cells for each week: Est and Actual. At the end
of each row, I would like a row total for Est and another for Actual.
As there are 20+ weeks represented, I cannot select the cells that have
the criteria I'm looking for without using a more complex formula than
SUM. Any ideas?
The spreadsheet looks like this:
Project Name Apr 3-9 Apr 10-16 Apr 17-23 Total
Est | Actual Est | Actual Est | Actual E | A
Project A 20 | 22 40 | 37 25 | 26 85...Conditional sum
Can you help?
I would like to sum a matrix according to a condition in a row and in
different condition in a column. I know how to do this one dimensionally
(either in the row or the column) using sumproduct, but what about two
Let me give an example, number of widgets produced each week by each type of
A B C D
1 weeks>>1 2 3
2 Type 1 10 15 11
3 Type 2 20 5 10
4 Type 1 5 12 21
So, I’d like the formula to be a...Insert Static Date as part of Macro
I've built a nice macro, but I want it to insert the date it is run in an
empty cell within the macro's range. When working within a spreadsheet, Ctrl
+; returns the system date, but I can't figure out how to put that command
into a macro.
The macro recorder editor shows that the system recognizes the entry as the
current date, not a function that returns the current date.
The now() or today() functions are both dynamic ... they change with the
system date. That's not acceptable in this situation. I need to seen when
the macro was run.
Thanks for any help,
di...Hide columns if there are no entry's in column
I have a workbook with multiple sheets. One sheet is a overview from
all the sheets and had all dates in it.
Is there a VBA to hide columns when there are no entry's in it?
The code has to work when I open the sheet "overview"
Hope someone can help me with it!
Thanks in advanced!
If you have a row that when blank would indicate which columns to hide, you could use
On Error Resume Next
Rows("1:1").SpecialCells(xlCellTypeBlanks).EntireColumn.Hidden = True
MS Excel MVP
<firstname.lastname@example.org> wrote in message news:118...How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
In the code behind the worksheet, enter (eg)
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
This will enter in Cell A1 the date and time at which any entry is made in
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
Return email address is n...Missing column letters
I have lost the letters at the top of my columns and the
numbers to the left.
I don't know what I have clicked! Any help is appreciated!
tools / options / view tab
ensure row & column headers are ticked
"Julia" <email@example.com> wrote in message
> Hello there,
> I have lost the letters at the top of my columns and the
> numbers to the left.
> I don't know what I have clicked! Any help is appreciated!
...How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
This is driving me ABSOLUTELY NUTS!
How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?
If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
columns (something that doesnt happen if I paste out of FireFox, fwiw).
But it pastes with all the formatting & URLs etc - which I DONT WANT!
OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!
ship w...zz report date truncation
We run only z reports at end of day. We will be running cashier shifts soon
and would like to run z and zz reports the way they were intended. Is there
any way to truncate the zz report date for each register without it running
since the beginning of time and using a truckload of paper?
Thanks in advance!
This may not be the most graceful solution, but you could simply turn off
your printer before 'printing' the zz report. Then manually delete all print
tasks for that printer before turning it back on. The report won't print,
but RMS will think it did.
"TV hardwa...Dead space at end of column
I am working on a multi-paged document that is legal-sized, landscape
orientation with three columns on each page. At the end of page two, I have a
recurring problem with the cursor jumping to page 3 about two-thirds of the
way down the column. I cannot type in that area. Displaying formatting
characters reveals nothing to show that there is a problem there. This does
not happen in any other location on the document.
Check the jumping paragraphs to see if many of them are formatted as "Keep
with next" and "Keep lines together." Or perhaps one as "Page b...Text in column causing SUMPRODUCT error
Greegings. I have a SUMPRODUCT formula that is having errors when one of the
columns has text instead of a NULL or a number. If I delete the text cells
in that column it works as desired. I'll give a simple example. Suppose I
have the following in A1:B6....
And I need this...
It errors out until I delete the "abc" in cell B3, then it works as desired.
I tried to replace the "abc" with a 0 by trying this...
And it works for that pa...Historical IV Trial Balance
When running this report in Summary, I am receiving an error when trying to
run with a date range. Has anyone seen this before?
are you getting a duplicate error? If you are, then what you are experiencing
is a bug. To fix, you will have to apply the latest service pack.
Hope this helps.
> When running this report in Summary, I am receiving an error when trying to
> run with a date range. Has anyone seen this before?
I think so. I'll try that by applying SP 4 for 10.0
> are you gettin...Excel
I would like to know if there is a way to set up when I enter the data
each cells on first row, it will default the date and time stamp on
first row. 2nd row should have the different date and time stamp than
I put "=now()" but it create the same date and time for 80 rows. I
don't want that. I want to enter each rows and each rows should be
different by one minute apart but same date - June 22.
Your help would be much appreciated.
Format A1:A79 as Custom dd-mmm-yy h:mm
Hold down CTRL Key and hit semi-colon key then <space> bar.
Sti...Forwarding balance for running sum
I created this query with a running sum, which is sorted by date then by
transaction number. I put this into a form for entering transactions for an
investment money market account. It works very well.
However, now that I have one years worth of data in there, I would like to
limit the data for the form as well as for reports. As soon as I limit the
data range, I loose the beginning balance.
Can anybody give me an idea on how I could create a beginning balance when I
select a date range or a starting date?
>I created this query with a running sum, which is sor...Macros and Active X
My ctrl+c and ctrl+v shortcuts dont work unless I turn on my active
forms bar to edit mode. Any guesses why
Message posted from http://www.ExcelForum.com
Because the spreadhseet is "live". You have to go into edit mode t
make any changes to control toolbox items.
Message posted from http://www.ExcelForum.com
I'm not trying to edit my active x forms, The problems is that th
standard ctrl+c and ctrl+v copy and paste short cuts wont work unles
the active x edit mode is turned on.
I don't have to turn on the active x edit mode to use these short cut
in other wo...Date changing 2028....2029......1930???????
I have a slight problem, in my form i have a date section which is automated
as 00/00/00. I use these for part of a report as a from this date to this
date, if you put 010125 it will automatically change it to 01/01/2025. The
thing I have found is that it is fine until you get to 010130 and then it
saves it as 01/01/1930 :-/ any ideas?
Message posted via AccessMonster.com
Assuming you're using XP, go to Regional Settings in the Control Panel, and
click on the Customize button. Look on the...Showing the perimeter of a set of (X,Y) data!
Good day all,
I need to plot the perimeter of a set of data.
I have a set of (X,Y) data with error bar and it is a nice mess so I
just actually need to see (show) the area were the data can be found.
Then hopefully overlay an other set of (X',Y') data and show that they
both cover the same surface of existence.
i.e this is a set of metrology measurement in X and Y of a part build
from different mould. Obviously you get a nice cloud of X and Y but
does the new material offer the same 'cloud' ?
I think the easiest way to do this is plot the data on a XY Scatter cha...