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 Last Post Reverse Sort Order Replies Views
Insert Data From Multiple Worksheets Into One (With Criteria) by Robcole84
Ok, I have created a sales report list that tracks what customers we are contacting, how we are contacting them, if they are a new or existing customer and...
February 9th, 2010 03:36 PM
by Robcole84 Go to last post
0 118
duplicate numbers being given different rankings by Mantis
Have list of percentages which have been sourced from another sheet within an excel document - when i rank these some duplicates are given the same ranking...
February 9th, 2010 03:30 PM
by Bernd P Go to last post
2 133
Extract portions of text by Lupe
Hi, I have a list of names comprised like this: Cook, Mr. M.S. Marty, Miss M.S.R. Constant, Mrs. R.G.L. We only have Mr., Miss and Mrs. I need to extract...
February 9th, 2010 02:57 PM
by Jacob Skaria Go to last post
2 91
Consolidation if a least one criteria is met by Nicawette
Dear all, I have the follwoing Name Value Criteria Aby 7 #N/A Oby 9 #N/A Ubi 1 #N/A Orbi 9 Yes Aby 6 Yes
February 9th, 2010 01:48 PM
by Ashish Mathur[_2_] Go to last post
4 242
Stock control spreadsheet by Rocket
I thought I had posted this previously but ommited the subject and I don't think it did post. Although I have used Excel for years I have never had the need...
February 9th, 2010 01:42 PM
by Rocket Go to last post
0 149
Stock control formula by Rocket
Although I have used Excel for years I have never had the need to use a complicated formula. I am trying to set up a stock control spreadsheet where multiple...
February 9th, 2010 01:15 PM
by Rocket Go to last post
0 100
How convert Numeric number in words by Imran Murtaza[_2_]
Is there any easy formula or way to convert numeric values in words? For example in cell A1 there is an amount 19549. How could it will be automaticaly...
February 9th, 2010 11:59 AM
by Mike H Go to last post
2 137
Function needed? by Annie
I need to learn how to compare two spreadsheets in Excel to identify differences between the two. For example, if I have one spreadsheet with a list of staff...
February 9th, 2010 11:43 AM
by Jacob Skaria Go to last post
1 95
Is there a formlula to replace cell shade color with another color by Newsgal
Is there a Find and Replace type of formula where which will find cells with a formatted with one pattern color and replace them with a new pattern color.?
February 9th, 2010 10:21 AM
by Rick Rothstein[_2_] Go to last post
4 94
If count by js20217075
start date end date 01/01/2010 01/01/2010 01/01/2010 01/01/2010 01/01/2010 01/01/2011 01/01/2010 01/01/2010 I want...
February 9th, 2010 10:08 AM
by Anand[_5_] Go to last post
6 87
Weeknum in 2010 incorrect by Paul Janssen
Hello, we encountered a faulty weeknumber generated by MX Excel for all dates in 2010 as of Jan 3d, 2010. This should be weeknumber 1 until January 9th, 2010...
February 9th, 2010 09:21 AM
by James Kew Go to last post
6 174
Another SUMPRODUCT Question by enna49
Hi Not certain whether this can be done. What I am trying to do is count the No of Accounts, the report could have many rows of the same Account No and I...
February 9th, 2010 06:32 AM
by T. Valko Go to last post
5 117
Check inputdate, then retrieve data to fill in chart from dated co by Kozmik
ok hope I can explain this.. I have a sheet with dated columns and the first row is employee names each dated column is filled with letters that correspond...
February 9th, 2010 06:15 AM
by Jacob Skaria Go to last post
2 117
5th Char in a cell by enna49
Hi I know this is simple, and I know I should know it, but I cannot get it to work and I have searched Help and the answers seem more complicated than what...
February 9th, 2010 06:01 AM
by enna49 Go to last post
3 121
how do I convert an imported number to text by Lyn
I am downloading data from a computer and wish to convert the number to text in an excel format eg: 0 = pump #1there is a series of numbers from 0 to nine...
February 9th, 2010 05:19 AM
by Jacob Skaria Go to last post
1 111
If,Then Statement by Lizz45ie
How do I write a If statement that compares the next row and then divide a number that is in another column. Here is an example of my data: sales order ...
February 9th, 2010 04:35 AM
by Sheeloo Go to last post
1 92
Date minus work days by HK[_2_]
In A1 i have: 29-May-2010 In A2: 20 (workdays) In A3: 13-May-2010 (holiday) In A4: 24-May-2010 (holiday) I need to find the date of A1 minus number of...
February 9th, 2010 03:52 AM
by HK[_2_] Go to last post
8 117
Dependent dropdowns by Dave
Hi, XL2003 I have many named ranges in my workbook. Relevent ones a "Components" "ResTH" (without the quotes). On my worksheet: Cell A2, Data Validation...
February 9th, 2010 02:25 AM
by T. Valko Go to last post
4 138
Convert variable #'s in a gen. format to a # that can be used w/ma by Steve
I have this data that is pasted to my worksheet: Period: 01/23/2010 to 01/29/2010 - Days: 6 It is in general format. The day numbers will always be in the...
(Multi-page thread 1 2 3)
February 9th, 2010 02:19 AM
by T. Valko Go to last post
29 253
retrieve data from different workbook by jat
good day, I have workbook A and workbook B; in workbook A cell C9 has a value (31); in workbook B, there is a worksheet named 31; regardless of the...
February 9th, 2010 01:54 AM
by Don Guillett[_2_] Go to last post
1 98
Post New Thread


Display Options
Showing threads 3121 to 3140 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 11:54 AM.


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