A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Formula I can't figure out by dpgreen
I know this is a strange request and it maybe difficult to do without seeing the whole spreadsheet but I am fairly new to excel and I can't make heads or tails...
November 15th 12 10:25 AM
by dpgreen Go to last post
2 413
Month Calculation by Moideen
Pls help me to get the below mentioned matter. Coloumn 1 (Invoice Date) : 05-07-2012 Coloumn 2 (Limit the Period) : 5 Coloumn 3 Need Result : 05-12-2012
November 14th 12 08:32 PM
by Moideen Go to last post
5 505
Using IF, AND and OR functions together by ahs004
Hi, I need help with using IF, AND, OR functions together. Here is my problem. I have cell C5 and E5 G5 and I5
November 14th 12 03:17 PM
by Claus Busch Go to last post
2 461
Search Text and Add a Blank Line by kojack
Hi All, New to the forum and have been searching (here and Google) for an answer with no luck. I am trying to automate the process of searching for specific...
November 13th 12 07:42 PM
by kojack Go to last post
2 460
Criteria length limit in SUMIF() by BAC
XP Pro/Office 2003 PRO Is there a limit on the number of characters that can be used in the criteria section of a SUMIF()/COUNTIF() function? Columns A & B...
(Multi-page thread 1 2)
November 12th 12 01:03 PM
by Kim_Matthijssen Go to last post
15 4,549
1 Attachment(s) Pls Help - blank cell/formula issue by Shokra
I am creating a Wages, Hour and Payroll summary for my fiancé because he's trying to keep track how the new company is handling wages/time schedules, etc. ...
November 11th 12 10:59 AM
by Claus Busch Go to last post
8 960
VLOOKUP or SUMIF for Multiple Criteria by Rob Kein
Im hoping this is possible. I am looking for a formula that will sum a large range of data in a specified column corresponding to multiple criteria that does...
2 692
Setting a range in a named range by Askjerry
Let's say I named the first column "ALPHA" and that I want to perform some function on it... If I use this... Set myRange = Range("A2",...
November 10th 12 01:29 AM
by Ron Rosenfeld[_2_] Go to last post
3 486
Help. Trying to do the opposite of VLOOKUP by Randy Sauve
I have a specific number X in a cell and in the column beside I have a list of data that ranges from smalles to largest. I need to find a number in that...
November 9th 12 10:04 PM
by plinius Go to last post
3 625
1 Attachment(s) Time Zone Conversion Table by naven_sg
Hello All, Need a Help in Conversion of Time Zone. I have a table in MST Time Zone, with 30 minutes interval. The data shows how many FTE working during that...
November 9th 12 06:50 PM
by Ron Rosenfeld[_2_] Go to last post
2 418
Help on the Sumif Function by matt_writer
I have a budget table where I input data every week. I want to create another table that shows how much I've spent every month. So for the Month of April my...
November 8th 12 09:05 PM
by joeu2004[_2_] Go to last post
1 399
Stumped on how to complete. by Pinnum
I am working on putting together a spreadsheet that will randomly match based on criteria that fall within a certain standard. This is basically it: I have...
November 7th 12 09:35 PM
by Pinnum Go to last post
0 414
2 Attachment(s) Count value in range, but exclude based on adjacent value. by amacrab
Hi. In the attached spreadsheet, is there any way to count the number of times "A" appears in column B, but exclude the times it appears next to "saf" in...
November 7th 12 02:02 PM
by Spencer101 Go to last post
4 524
Sunday by Dale[_4_]
This is probably a very basic question so I apologise first, how would I calculate the last sunday of a given month? Once I have that date, I need the...
November 7th 12 10:27 AM
by Michael (Micky) Avidan Go to last post
8 1,204
Excel Template required for Daily managing daily income and expense at Mobile shop by nevillmehta
Dear All, I have newly started a Mobile shop and want to use the power of Excel for Daily accounting. Can anybody help me in creating template for my...
3 1,766
Remove punctuation mark, Split cells & average accross column by Gautam Bhut
I have data in column like this. 50 50/152 56 150/150 20
November 7th 12 09:32 AM
by Gautam Bhut Go to last post
4 621
LOOKUP function?? by [email protected]
Hi Guys - I have a simple dataset that counts illness occurance in a wee. Something like this: A B C D E 1 ...
5 561
1 Attachment(s) Summing up cells based on names in adjoining cells - I'm new to using functions by Stupidparrpt
I have a column with agent commissions for sales orders. Next to this column I have a column with the agents identifier (names in this case). I want to create...
November 6th 12 11:58 PM
by Stupidparrpt Go to last post
2 493
1 Attachment(s) Median Formula not working properly by RK_Excel
Hi, I used the following formula to find the median for a range of numbers. I assume variable p in the below formula as...
November 6th 12 11:55 PM
by joeu2004[_2_] Go to last post
2 726
How to keep random number from changing using RANDBETWEEN? by TXlimogirl
I am trying to generate a set list of random numbers between 1 and 42 using the RANDBETWEEN formula. The problem is everytime I click another cell anywhere in...
November 6th 12 11:38 PM
by coty Go to last post
5 13,194
Post New Thread

Display Options
Showing threads 1001 to 1020 of 88501
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.