Summing weekly values to fall into correct month
Could someone please help me with this .
My spreadsheet has row data in weekly buckets . I would like these weekly
amounts to be summed to form the corressponding monthly total . However ,
some weeks are split across 2 months.
For e.g. w/c 28/06/10 has 3 days that fall into June and 4 days that fall
1) How do I get excel to add up all the weeks in June, and for this
particular week, instead of taking the full weekly value into June ,
calculate the value/7 * 3 days ?
2) How do I get the following month of July to also add in the value/7*4
days from this week...printing checks with account name and number
I can not seem to figure out how to print checks and have
the account name, number and the bank it is drawn on
printed on the check.
"Lynn" <firstname.lastname@example.org> wrote in message
> I can not seem to figure out how to print checks and have
> the account name, number and the bank it is drawn on
> printed on the check.
...Deleteing Part numbers
Does any body know how to delete a part number that has history. I have been
told that you cannot delete any part number that any history. As far as
anyone knows in my department it cannot be done.
You have to remove history for that item before you delete it.
"James Rodgers" wrote:
> Does any body know how to delete a part number that has history. I have been
> told that you cannot delete any part number that any history. As far as
> anyone knows in my department it cannot be done.
...Number Format #13
How to format say 123456789 in the format 12,34,56,789. This particula
number format is being used in India. (grouping of 2 digits rather tha
3 excluding the last 3 digits
harikrish's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2710
View this thread: http://www.excelforum.com/showthread.php?threadid=46647
What version of Excel.
In Excel XP see function BhatText as in Thai Bhat currency. =BAHTTEXT(A37)
If you just have positive numbers you can use as custom format like:
[&g...summerizing formula for weekly lesson plans
This is a request from a primary school headteacher and a good friend of
They use an excel sheet that shows the lesson plan for each teacher. Nothing
special on it. But lately they needed some summerizing figures on the
For each teacher, there are "names" in the region G10:K19 in its excel
sheet. The names includes a part consisting of the "lesson name" itself and
a part consisting the "class" that'l take it (For example "ScienceA1"). Thus
the "name" data can easily be seperated because the "lesson name" is at th...variable number formats
How can I format a set of cells to dispaly varying decimal place
depending on a value in a different cell.
if "A5" < 1 then format cells G10:G20 to five decimal places,
if "A5" < 10 then format cells G10:G20 to four decimal places,
if "A5" < 50 then fomat cells G10:G20 to three decimal places,
if "A5" < 100 then format cells G10:G20 to two decimal places,
if "A5" < 500 then format cells G10:G20 to one decimal place.
I have used the function, Round(num,x) but this does not do the tric
most of the time. It does not dis...Non Sequential Serial Number from Excel
How can i use or modify a macro that will read from an excel file during
Serial Number creation using the Serial Number Insert Window in Receiving and
Inventory Transaction Adjustment Serial Number Insert window.
Any help is greatly appreciated.
You may want to look at Binary Stream's Serial Lot Copy&Paste Manager module.
Charles Allen, MVP
> How can i use or modify a macro that will read from an excel file during
> Serial Number creation using the Serial Number Insert Window in Receiving and
> Inventory Transaction Adjustment Serial N...Weeks
I am trying to work with date. I want to see in a cell the week numbe
with the stating date of that week and the ending date of thta week
Week #1 - 01 jan 2004 to 03 jan 2004
Week #2 - 04 jan 2004 to 10 jan 2004
Week #3 - 11 jan 2004 to 17 jan 2004
end so on.
Can anyone help me.
Message posted from http://www.ExcelForum.com
With the assumption that you store the weeknumber in column A and use
the ISO definition for weeknumbers (Have a look at
http://www.cpearson.com/excel/weeknum.htm for more information on this
topic) use the following:
1. To calc...row number in Excel
I am using ODBC to connect to an Excel database, does anyone know of a function that I can use to select from row 50 to 100 of a spreadsheet. So, is it possible to use an sql statement on Excel database to get a range of rows? Does Excel have a row number function?
...Formula to see if a number is allocated
I need to find out if a number is allocated or free. Basically on sheet1 is
a load of information. in Column G on this sheet is a unique identifier
In sheet2 I have a list of numbers say from 1-100 which correspond to the
identifier numbers in sheet1. Id like a forumla something like:
"If A1 in sheet 2 = any number in column G in sheet1, then print Allocated,
else print free"
At the moment I have: =IF(A1=Sheet1!G:G,"allocated", "free")
But it does not work. What it is doing is If A1 = everything in column G
then say allocated, else say fre...BKF-Display Results (a number) on form from a query
I have a query that will count all Active Customers based off Account
Numbers (unique). The query when run will obviouslly give me a count but can
I get that count to display on my form so that I can always see a count as
customers are added and deleted.
100 displays as current
101 diaplays when I add a customer
99 Displays if I remove a customer
...How can I match numbers from two columns?
I have two columns with numbers. Some numbers are in both columns, some not.
What I need to get is some formula that can compare both columns and tell me
wich numbers are already in column 1 and what numbers are not.
Something like this:
234 222 It's not in column A
444 300 Yes, it's in column A
300 150 It's not in column A
I'll appreciate any help!
One way assuming the list you want to check is in column B starting in
row 1, in C1 enter the formula:
=IF(ISNA(VLOOKUP(B1,A:A,1,0)),"It's not in Column A","Yes, it's in
column A&q...Calculate the beginning of the week
I want to have a field in excel that gives me the "week of" date.
For example, today is 4/25/06.
The field would show the "week of" 4/23/06 because that is the date of last
I want it to automatically calculate the 'week of' data from today's date.
Is this possible? If so, how do I do it.
"Jaz" <email@example.com> wrote in message news:O2Yi5wHaGHA.4116@TK2MSFTNGP05.phx.gbl...
|I want to have a field in excel that gives me the "week of" date.
...Budget weekly total don't add up
When setting up my budget, I set my income as a weekly
amount but the total doesn't add up to the four weekly
What is causing the problem?
Try weekly * 52 wks/yr / 12 months/yr. There are more than four weeks per
"DJ" <firstname.lastname@example.org> wrote in message
> When setting up my budget, I set my income as a weekly
> amount but the total doesn't add up to the four weekly
> What is causing the problem?
...Wrong numbers on axes
I have encountered some strange numbering problems on
graphs in a number of my files. The x axis time values:
1 2 3 4 5 6 7 8 9 10 11 12 13 are appearing in some graphs
1 2 3 4 5 6 7 8 9 1 1 1 1
All the graphs's axes label source is the same set of
cells. Changing the cells to different ones makes no
difference, the difference seems to be in each graph's
settings. In some other graphs I am getting a similar
problem, the numbers 1-31 having the 20s appear as 2s.
Interestingly if the axes is formatted as a number to 2
decimal places (in the faulty graphs) you end up
w...Auto number items
I am looking to put a number in a all of the different types of boxes on my
diagram. I have been creating a text box with a number and dragging it to
the box. I was in hopes that there might be an automated process.
Have you tried Tools/Addons/Visio Extras/Number Shapes...
"Chip Asmus" <Chip@lawlershallmark.com> wrote in message
>I am looking to put a number in a all of the different types of boxes on my
>diagram. I have been creating a text box with a number and dragging it to
>the box. I ...Maximum number of stores for E2K Enterprise
We're having a disagreement here!
What is the maximum number of stores supported for a single Exchange 2000
Enterprise server? 16 or 20?
If you can help me out with a technet link that would be awesome!
Four storage groups; 5 databases per. (Total: 20 databases)
Ben M. Schorr, OneNote-MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
**I apologize but I am unable to respond to direct requests for assistance.
Please post q...Graph: number of curves
What is the maximum number of curves (series) in a graph ?
In article <79axf.14930$W03.email@example.com>,
> What is the maximum number of curves (series) in a graph ?
Check XL help for 'Excel specifications and limits' (w/o the quotes).
It contains a section on 'Charting specifications'
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Charting limits are,
Data series in one chart 255.
Data p...extracting numbers and adding
Using XL2002 for Windows, I want to extract and add numbers from cells.
for example, let the following 3 lines each represent 1 cell.
How can I extract the numbers then add them. For example...
D2K13 V0F4 = 2+13+0+4 = 19
Y2 = 2
H10T4 = 10+4 = 14
Is this possible?
You could set up a User Defined Function to replace all characters with
a + in the string, and then pass this to the Evaluate function. If you
are likely to have two or more letters next to each other then the UDF
would have to detect for this.
I'm about to go out now - I'm...Charting with concatenated numbers and text
I am scatter charting from columns of data (text and
numbers) that I concatanate into a long string so that I
can use the validate drop down list feature in Excel,
which only supports one column. I use Mid, Left and Right
functions to then pick the relevant charting data from the
Unfortunately although the numbers look good, Excel
does not treat them the same way that it does with
directly entered numbers - and my charts do not display
Any ideas to to fix this problem or suggest a modified
workflow. I am not an advanced user but would like to use
the drop down li...TTGErrors Number: 430
I've installed a VB6 application that I developed in a
workstation that is using great plains. Now, when they
run Great Plains and go to Tools, Integration an Internal
Error in TTGErrors occur. The details of the error:
Message: Class does not support Automation or does not
support expected interface
I checked the current MDAC version isntalled on this
workstation which is MDAC2.7 SP1 Refresh. Is this error
being caused by the MDAC version? How can I resolve this...date to day of week ignoring blank cells
How can I covert dates to days of week eg 30/07/04 = Fri withou
converting blank cells at the end of the column.
Obviously, I can specify the column range to convert, but I wanted t
avoid this as it will be changing all the time. So I either need t
format the whole date column to "ddd" or use the weekday function - bu
this returns "Sat" for blank cells.
I then want to be able to count the number of times each day appears s
having the excess "Sat" cells at the end of my data is not helpful!
Message posted from http://www.ExcelForum.com
...Page numbers are not recognizing my headings
I just created an outline using headings so that I could have page numbers
that include my chapter number. However, when I try to format my page number
to include chapter numbers, it doesn't change how my page numbers appear (ie,
it should say 3-1, but instead it just says 1).
Any ideas on why this might be?
>I just created an outline using headings so that I could have page numbers
>that include my chapter number. However, when I try to for...How to not copy the numbering from numbered list in Word ?
I want to copy a numbered list in Word and paste to a text file.
The numbers show up. How do I not copy the numbers preceding the
Thanks very much in advanced.
By temporarily disabling the numbers and bullets in word before
you copy and paste the text. Then you can simply close the word
document (without saving it) so that no changes in the word file
That one time call girl may suggest that you should use Tipex on
the screen to remove the numbers!!! You have been warned.
> Hi !
> I want to co...Last Week, 2 Weeks ago...
I like to sort emails from my Inbox into Folders labeled Last Week, 2
Weeks Ago, 3 Weeks ago to make it easy to refer back to them if
customers contact me again. Outlook sorts the Inbox into sections
titled Last Week, Two Weeks Ago, etc. The way it sorts them goes by the
week SMTWTFS, but I don't receive e-mails that come in on Saturday or
Sunday until I arrive at work on Monday. I want all emails from SSMTWTF
to be included in the current week, because I will reply to all of them
throughout the week I work, MTWTF. In fact, I'd like the cutoff point
to be Friday at 4:30, and ...