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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Algebraic Function by Jpleasant
How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is...
May 27th, 2010 10:37 PM
by Jpleasant Go to last post
0 201
Converting a non recognizable date time by mlman
I have high speed monitoring equipment that imports thousands of date time readings as follows: 05/24/2010 14:20:00.000.084 Excel does not recognize it as a...
May 27th, 2010 10:36 PM
by Mike H Go to last post
1 247
Distinct Counts with Multiple Criteria by Bentam3
Each month we produce a complex report in Excel using thousands of rows of data. We've just been asked to add in a new table which needs to use distinct...
May 27th, 2010 10:35 PM
by Jacob Skaria Go to last post
1 232
Sumproduct using multiple sheets by Radhakant Panigrahi
Hi, I am using the sumproduct formula for multiple sheets. Below are my data which is contains from sheet1 to sheet3 when i use the sumproduct formula for in...
May 27th, 2010 10:35 PM
by Radhakant Panigrahi Go to last post
0 283
pick up particular number from a table by Lowan Chan
Hi, I have below table: A B C D E 1 04/10 04/10 04/10 04/10 2 AB YZ AB YZ 3 MARY 45 56 16 62 4 PETER 50 48 84 45 5 JOHN 60 78 65 50
May 27th, 2010 10:33 PM
by Lowan Chan Go to last post
0 193
View Conditional Formats on worksheet? by Bill E
Is there an easy way to scroll over a worksheet to see what the Conditional Formatting is for various cells? I know you can go through 'Format' -...
May 27th, 2010 10:33 PM
by Bill E Go to last post
4 437
Algrebraic Functions by Jpleasant
How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is...
May 27th, 2010 10:29 PM
by Tom-S[_2_] Go to last post
2 200
Extract numbers from a string of text by marcella63
Need to extract just the numbers at then end of the string. 1300 · Inventory:1305.05 · Inventory Business to Business:1305.10 · B2B Inventory Contra 1300...
May 27th, 2010 10:29 PM
by marcella63 Go to last post
0 267
ISNA and ISERROR functions by Emece
Hi. I need some samples of ISNA and ISERROR functiones. Is there a web where I can download samples of them? Thanks in advance Regards, Emece.-
May 27th, 2010 10:27 PM
by Emece Go to last post
0 186
Counting occurance of empty cells by DaveC
Hi folks, I am trying to set up a formula which will count the quantity of empty cells in Column K if there is something in the corresponding cell in Column...
May 27th, 2010 10:27 PM
by Tom Hutchins Go to last post
1 217
naming worksheet tabs by Jacob Skaria
Sorry, you cannot. Max length 31 Exception characters * ? / \ -- Jacob (MVP - Excel) "SHARON" wrote:
May 27th, 2010 10:25 PM
by SHARON Go to last post
3 265
Algebrais Functions by Jpleasant
How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is...
May 27th, 2010 10:23 PM
by Jpleasant Go to last post
0 185
Date Formatting by Mike H
Tommy, These rogue dates that won't format may be text that look like dates. If we have one of these in A1 try this formula =isnumber(a1) which should...
May 27th, 2010 10:22 PM
by Tommy Go to last post
1 225
how to change Rs.(value) to Rupees in words by asdf
How could i change value to words i.e., Rs.75 - (Seventy Five only)
May 27th, 2010 10:21 PM
by asdf Go to last post
0 212
Bankup of worksheet by shital shah
Hi I have I workbook I that I have more than 10 worksheet I want to take a backup of only 1 worksheet which name is “Data” that is to store in other...
May 27th, 2010 10:20 PM
by shital shah Go to last post
0 210
DEFAULT ITERATION - HELP NEEDED by Gary''s Student
I would include a macro that runs automatically when your workbook is opened. The macro would save the state of iteration and then setup iteration according...
May 27th, 2010 10:20 PM
by Paolo Go to last post
1 285
print only range that contain information in excel 2007 by tazman
i have a large worksheet to cover a large number of possible inserted entries, all cells show blank until entries are copied and pasted in the worksheet. The...
May 27th, 2010 10:19 PM
by tazman Go to last post
0 269
pick up particular number from a table by Jacob Skaria
Try the below with data in Sheet1 Col A1:E5 and the query values in current sheet...
May 27th, 2010 10:17 PM
by Jacob Skaria Go to last post
0 180
Pivot Table ... Stacked Col & Area Graph by Ken
Excel2003 ... I have a Pivot Table "Stacked Col" Chart reflecting operators & the time they charged to a part ... Sometimes an operation is completed by 1...
May 27th, 2010 10:16 PM
by Ken Go to last post
0 221
Correct a Cell by Olyr150
How do you clear a cell from doing this 1E+305? It should read 1E305.
May 27th, 2010 10:14 PM
by Brad Go to last post
2 190
Post New Thread


Display Options
Showing threads 421 to 440 of 139764
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 03:10 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.