I'm doing a projection spreadsheet. The new months in diff sheets will be
added as and when the actual month passes, ie, up to now i have sheets up to
Aug. But in the MAIN sheet, I'm supposed to have months for the whole year up
to Dec. Since Sep to Dec don't have equivalent sheets yet, the cells show
#Ref since my formula is =Oct!A1.
I want to tell the cell to get the amount from "Oct" sheet if there's such a
sheet and if not, get the amount from "Sep" sheet. I tried this
"=if(Oct!A1="#REF", Sep!A1,Oct!A1)" but it doesn'...Finding characters within a text
How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance
Hmm..not very elegant, but maybe
Returns TRUE if the text in A1 contains 'R', 'L' or 'Ps' .
FIND is case-sensitive, use SEARCH if you also want to find lower-case
Joerg Mochiku...Sql to find record in a hierarchical chain
Hi, lets say I have a table with 2 fields:
Field 1 - ref
Field 2 - parentRef
Now in the structure there could be numerous chains until you get to
the top of the hieratchy (where the ref field = parentRef field).
so in this 444 is top of the chain (there will be many other records
as well that are nothing to with 444 and are part of their own
hierarchy). So how do I easily relate 111 to 444. Ie how do i find
the ultimate top parent for a given 'ref' field.
Hope anyone can give me some pointers ...Need Formula To Find Blank and NonBlank Cells
I have a worksheet with 6 columns (by Month)
Sep Aug Jul Jun May Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>
So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
"hilltop55" <email@example.com> wrote in message
news:08D989CB-D1B4-49F...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...Where do I find SSADM 4+ templates in Visio ?
Hi, I understand SSADM 4+ templates were available in Visio 2002. I have just
moved from Smartdraw to Visio Professional 2003 and am having difficulty
finding SSADM 4+ templates.
Does anyone know where I can find these templates? Are they still available
in the 2002 version?
...XL 2007: How to find out what keyboard shortcuts I've assigned to macros?
Over the years, I've recorded and written a lot of macros. (Probably
time to take a week or two and go over them and delete at least
half!) I assigned a keyboard shortcut to a lot of them.
I seem to remember that before XL 2007, there was a keyboard organizer
that I could go through and review what shortcuts I had already
assigned to my macros. I can't find that in 2007, though.
Is there an easy way to generate a list of all my keyboard assignments
and what macros they go to?
I don't recall ever seeing any such keyboard organizer in 2007.
Canned from a prev...Find and replace with bold in cells
I have a VB6 program that is executing Excel 2007, opening a worksheet, and
extracting some of the cells to write data to a text file. Some of the cells
contain bold text on some (not necessarily all) of the text in the cell. I
would like to do a find and replace on the bold tagging to replace it with
something like "<b>" at the start of it and "</b>" at the end of it. How do I
set this up in VB6? Thanks!
The following function will return a string including <b> and </b>
tags from the text of cell R.
Function BoldMarkup(R As Range) As...time formats #3
I have an Excel sheet with a long list of times spent on various projects.
The times should all be in minutes and seconds. The first time reads 2:29
and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it
reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is
right, for 40 seconds. But in the formula bar, I see 12:40:00 AM
I want numbers, but apparently I am looking at times.
I tried changing the format. When I check the format for 2:29, it comes up
Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but
that changes the displa...Formula to find last monday (tue, wedn, thu or friday) for a given month
I need a formula to calculate the date of the last monday, tuesday,
wednesday, thursday or friday of a given month.
Can't seem to find the answer anywhere.
day: wednesday (or corresponding nr)
Who can help?
Thank you for reading and eventually answering my question.Back
Microsoft MVP - Excel
"Michele" <firstname.lastname@example.org> wrote in message
> I need a...New Computer #3
How do I move my settings, emails, address book, etc...
to my new computer. I'm mostly concerned with Outlook
because it's the program I use most often. I have an
older computer running WIN2K Pro. I purchased a new Dell
computer with Windows XP Pro also with Office 2003. Again
how do I make my new Outlook have all the information and
settings that my old computer has. I do have both
computers connected on my home network and they can see
each other. But I'm not sure what to copy over. Any help
would be very helpful. Thank You, Paul
The file you need to copy and re-use up ...CRM 3.0
Any way that we can assign leads / opportunities / other entities to teams
rather than individuals?
All the best
Team ownership is not supported in CRM 3.0. Could you describe your
scenario, and maybe we could provide some alternatives?
Microsoft Dynamics CRM
This posting is provided "AS IS" with no warranties and confers no rights.
"Electronic Workplace" <info@electronicworkplace.LoseThisBit.com> wrote in
> Any way that we can assign leads /...Importing #3
I had a previous version of Money and just got a new
computer with Money 2004. I have a backup disk made with
the info from the previous version. How can I import that
into the new version?
<email@example.com> wrote in message
> I had a previous version of Money and just got a new
> computer with Money 2004. I have a backup disk made with
> the info from the previous version. How can I import that
> into the new version?
...I can't find outlook express on my Mac?
I found a folder called Outlook express, but there is no actual program. I
have Internet Explorer, should't I also have Outlook Express?
what version of IE is installed?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messa...Debt Reduction Planner #3
The debt reduction planner on my version of Money 01 does
not take the minimum payment due into account. It expects
me to short some accounts to make bigger payments to
other accounts. Obviously that is not feasable, as the
late charges for not making the minimum payment would
negate any possible savings. Is there a way to fix this
so at least the minimum payment is listed?
...Converting from Lotus 1, 2, 3 docs
I have a user who has a bunch of Lotus 1, 2, 3 spreadsheets that he is
trying to convert to Excel. His version of Lotus is old (version 5), his
version of Excel is 2000 sp2. The files convert but they are missing pages
or headings or other unacceptable qualities. Anyone any advice?
If you open the files using Excel and save them to an .xls format in the
current version you are losing data?
A while back I needed to do this. I wrote an application in VB that loops
through the files, opens them using Excel (add a reference in VB to MS
Office 10) and then save them in the current ...Calculating dates #3
Can anyone tell me what I should use (in the way of helper cells)
to take any date (mm/dd/yyyy) and turn it into that same month
and day for specific year? For instance, turn...
10/12/2009 into 10/12/2010
4/6/1998 into 4/6/2010
I'm trying to determine anniversary date based on start date and
do it starting in 2010.
Assuming your date is in A1.
Hope this helps.
On Jan 5, 5:35=A0pm, Jordon <jordon@REMOVE~THISmyrealbox.com> wrote:
> Can anyone tell me what I should use (in the way of helper cells)
> to tak...Cell References #3
I have 2 separate work sheets. I want to copy the values of cells in work
sheet A to cells in Work sheet B. The values in A are separated by at least
4 rows. Cells in B where I want those values are separated by 1 row.
How can I copy the values without having to enter each cell reference
indivudually in B?
Is there a formula to add columns or rows such as cell A1+3 = cell D1 or
cell A1 + 3 = cell A4
> I have 2 separate work sheets. I want to copy the values of cells i
> sheet A to cells in Work sheet B. The values in A are separated by a
> 4...Sent faxes in CRM 3 doesn't show in history
I am reposting this as I've had no answers to my previous post which is now
buried in all the other ananswered posts. Surely someone knows the answer to
this??? It's pretty fundamental to what customers will want. Anyone???
I'm using CRM 3 under SBS 2003.
When I send a fax using the "New activity / Fax" option within a contact
record it sends successfully. . However there is no record of it stored in
the contact history?
If I check the fax console on the server the fax has been sent (also
verifi...Finding text within text
I've gotten the formula for finding occurrences of a word in one
column based on whether it's in another column; now what I need is to
find out whether a word in column A (for instance) appears in a string
of text in column B. As in, a SKU in A, and a description in B, with
the descriptions having several SKUs in each one. I need to be able
to delete from a sheet any description that doesn't have the SKUs I'm
looking for, and it would be really nice to color the corresponding
cells the same, but even having the row number in the third row would
Say I...Outlook Express address Book #3
My address book is no longer visible. How do I correct
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program despite its similar name..
You will probably get a faster and more expert answer if you post this to an
outlook express news group.
Try posting in one of these newsgroups:
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
microsoft.public.windows.inetexplorer.ie55.outlookexpress for OE 5.5x
microsoft.public.windows.inetexplorer.ie6_outlookexpress for OE 6.x
...Analytical Accounting Error #3
I am getting the error 'This record has been created since your attempt to
create. Changes will not be saved'. This I am getting while I am trying to
add additional transaction dimension.
...Windows can not find my spreadsheet
I repaired and uninstalled then installed Office 2007. I opened Excel up and
search for my Excel Spread Sheet and open it and then save as on my desktop
like I always do. Then when I double click on the Icon I get "Windows can
find C:\User etc. Make sure you typed the name correctly, and then try
again. Any excel spreadsheet I have I get the same message when I double
click on it. I check the path and it is correct.
Check your other post.
> I repaired and uninstalled then installed Office 2007. I opened Excel up and
> search for my Excel Spread Sheet an...IF statement with FALSE value being text AND cell reference? #3
Once again, figured it out on my own. Oh, and thanks for the repl
Needed to use the ROUND function:
=IF(D9>1,D9*D8,"<" & ROUND((D9*D10),2)
jcob2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1560
View this thread: http://www.excelforum.com/showthread.php?threadid=27157
...MS CRM 3.0 - Availability of User for Assignment
I am having this unusal requirement. I am having 3 Businsss Units with its
I have set Roles for all the Users from All the BU such that they can
view/read Users from their own Business Units. So whenever User assigns the
record they can assign it to any User withing their BU.
However I have requirement where a specific User can be assinged to the
record by Users in any BU. This user can be in any BU (it can have its own BU
also). So special Incidents can be assigned to this Special User by Users in
How to achieve this by Roles configuration? I tried all...