A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
Date question by Ziggy
Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS
April 18th, 2010 03:22 PM
by T. Valko Go to last post
3 222
SUMIFS using a text range by Ziggy
I am still new to Excel 2007. I want to start using SUMIFS for their efficiencies over array formulas. They don’t seem to work the same. I want to sort by Dep...
March 29th, 2010 01:35 AM
by Ziggy Go to last post
2 149
SUMIFS using a text rage by Ziggy
I am still trying to make the conversion from 2003 to 2007. In particular I'm trying to understand the SUMIFS since they are more efficient than arrays. I...
March 23rd, 2010 05:41 PM
by Ziggy Go to last post
0 141
how do i transfer dada from one spread sheet to another by ziggy
how do i transfer dada from one spread sheet to another
April 13th, 2007 10:56 PM
by MyVeryOwnSelf Go to last post
1 60
SUMIFS using a text rage by Ziggy
I am still trying to make the conversion from 2003 to 2007. In particular I'm trying to understand the SUMIFS since they are more efficient than arrays. I...
March 23rd, 2010 05:41 PM
by Ziggy Go to last post
0 109
Random Values by ziggi456
Hi I have a list of people (approx 200) and need daily to pick 20% of these people on a random search
September 9th, 2008 11:55 PM
by Max Go to last post
7 91
How to make userform work publically with hidden sheets? by Zigball
I need help I am unsure of what is going on. I have five userforms and five worksheets.. and an additional worksheet for reference page. The useforms are...
October 25th, 2006 03:30 PM
by Zigball Go to last post
7 99
FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL by Zigball
HELLO GOOGLE GROUPS I HAVE A PROBLEM, I NEED TO MAKE A SPREADHEET THAT IS BEYOND MY CAPABILITIES SO I AM ASKING FOR YOUR HELP. THIS FORMULA THAT I NEED TO ME...
(Multi-page thread 1 2)
January 13th, 2007 11:30 PM
by Don Guillett Go to last post
10 88
How to Prevent Duplicate Data from inputing using input application? by Zigball
Hello microsoft.public.excel.worksheet.functions my name is Zig I am trying hard to find out how I can use a input application to input data into a specified...
October 16th, 2006 11:01 PM
by Gord Dibben Go to last post
8 51
Help with creating a search engine in excel vba by Zigball
I am able to input data, I am able to scroll through a hidden excel sheet that stores the input data by using the application. I want to be able to use the...
October 20th, 2006 01:14 AM
by Zigball Go to last post
5 51
Cleaning Specific Data withing a range from a cell by Ziantist
I have nested some Numbers into , into a description column. What i would like to do is extract the numbers between these ' s example; 3/4" EMT ON STL 3...
August 8th, 2008 11:35 PM
by Teethless mama Go to last post
2 84
VLOOKUP business case by ziak
Hi - I need help with an issue and it's best to give some background information first....please read and bear with me! I am addressing a compliance issue...
May 17th, 2007 04:19 PM
by ziak Go to last post
2 66
FIND A VALUE FROM CROSPONDING COLUM AND MULTIPLE CROSSPENDING ROW by Zia Butt
S.NO Name "Pay Date/Paid Date" A B 1 Zia 01/01/2010 2 03/01/2010 3 amir 12/12/2009 4 01/01/2010 Find the value for Zia (A1) from crossponding...
February 2nd, 2010 01:55 PM
by Jacob Skaria Go to last post
3 107
SUMIF multiple criteria by Zia
Hi, I have two columns A and B. A column has Account # and B column has amounts A B 10 100 11 200 10 300 13 400 14 500 11 600 Now I want to...
October 29th, 2008 04:37 PM
by Zia Go to last post
4 41
Traspose Column data into Row by Zia
Hi, I want to transpose column data in to row. I have seen many posts (using INDEX or OFFSET functions) but all these solution assume a fixed block of data...
January 6th, 2010 11:40 PM
by Herbert Seidenberg Go to last post
3 135
lookup with more then one codition by zia
can any one help me to using lookup function with more then one condition,
April 12th, 2006 06:31 PM
by Bob Phillips Go to last post
1 78
How do I set viewing passwords for worksheets in excel by Zhugeliange
I want to set specific passwords to view specific worksheets within a workbook in excel, i.e. only those with the proper password can view certain worksheets...
October 11th, 2006 07:50 PM
by JNW Go to last post
1 54
Question about SumIF by zhuanyi
Hello, I know this is really confusing, but...anyway.... Say for example I have 4 columns of data, the first contains, say, the name of the sales man, second...
August 11th, 2006 04:39 AM
by JMB Go to last post
3 90
How can i know how many rows in a worksheet? by zhoujinting
hi,everyone i have a problem.How to make the fcnction know how many rows in a worksheet? Can anyone help me?
December 11th, 2003 01:49 PM
by zhoujinting Go to last post
5 95
Movado Se Sports Edition Mini Womens Watch 0604835 by [email protected]
Movado Se Sports Edition Mini Womens Watch 0604835 Discount Watches Site : http://www.watchespurchase.com/ Movado Se Sports Edition Mini Womens Watch 0604835...
September 23rd, 2008 08:30 AM
by [email protected] Go to last post
0 558
Post New Thread


Display Options
Showing threads 241 to 260 of 87787
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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:49 PM.


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