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
120= rupees one hundred twenty only by digit to text
i just want to know the formula which translate digit to text for example if 120 written in any cell and other cell we want result "rupees one hundred twenty...
May 25th, 2010 06:46 AM
by bala_vb[_27_] Go to last post
2 293
Copying Certain Worksheets depending on certain criterion by Andy_N1708 via OfficeKB.com
I have an excel file that contains multiple templates that I need to copy depending on certain criterion. I have set up two columns for this purpose. The first...
May 25th, 2010 04:13 AM
by Andy_N1708 via OfficeKB.com Go to last post
0 343
month name by pat67
There is a function to show the number of the 1-12. Is there a way to show the name?
May 25th, 2010 01:36 AM
by T. Valko Go to last post
4 300
Lock in formulas by Malcolm
I have a worksheet that I use over-and-over again. It has several columns of data, and some of the columns have long and hard to remember formulas to total...
May 25th, 2010 01:16 AM
by Malcolm Go to last post
2 324
Excel 2003 Function Help by Ryan Hicks
I need help coming up will a function that will average a range in one column based on if the hours match. Here is my set up. -------A-------B...
May 25th, 2010 12:55 AM
by Ashish Mathur[_2_] Go to last post
4 319
find the correct sum by reza
HI EXPERTS, i hope you and excel can do this. i have a master data with so many rows. i.e A B C D No Name ...
May 25th, 2010 12:22 AM
by Max Go to last post
8 396
sum the color cells by reza
hi all. i have data with different color. i one column i have 3 color, blue, yellow and red. now i want to count & sum based on the colors. how to create...
May 24th, 2010 11:35 PM
by Gord Dibben Go to last post
7 593
May 24th, 2010 11:21 PM
by Gord Dibben Go to last post
2 236
May 24th, 2010 11:07 PM
by Gord Dibben Go to last post
4 224
Partial Text Match then enter desired result into appropriate colu by MMangen
I have a list of company names in Column A. On a separate tab I have a list of keywords. What I'd like to do is to have a search done on the names in column...
May 24th, 2010 11:03 PM
by Don Guillett[_2_] Go to last post
1 215
Principal & Interest Formula by Scoober
Hi all, I am trying to complete a principal & interest formula that remain empty in the target cell if no loan amount is...
May 24th, 2010 10:52 PM
by Niek Otten Go to last post
1 319
How to sum by month by Charles
I have a sales order spreadsheet that gets updated daily from our ERP system. The worksheet has the following columns: 1. Customer code (each customer could...
May 24th, 2010 10:45 PM
by Roger Govier[_8_] Go to last post
8 428
Button on Form to Add more rows by SaM
I have a form that I have created in excel and in one section of that form, I want to be able to add a button that will add 5 more rows for that specific...
May 24th, 2010 10:05 PM
by Otto Moehrbach[_2_] Go to last post
1 286
formula for adding up 3 different start and finish times by Shazza
Hi. Can any one tell me the formula for adding up 3 different start and finish times within a 24 hour period. I have set up a time sheet that has shifts of...
May 24th, 2010 09:15 PM
by Fred Smith[_4_] Go to last post
4 292
Count number of rows with specific text by Rock
I am using this formula to count the number of rows in Column C with text. =SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500))) I need, instead, for this...
May 24th, 2010 08:46 PM
by Rock Go to last post
2 271
personal.xls by pat67
Random question. for some reason my personal.xls file does not open when i start excel. it was now it isn't. for some reason i have to go into the folder and...
May 24th, 2010 08:23 PM
by pat67 Go to last post
3 246
Two Condition - search by linda
I am trying to pull value when two conditions are met. want to count column "B" when it = "ETARC" and when column "J" is = "0" or a negative number. I...
May 24th, 2010 08:13 PM
by Glenn[_6_] Go to last post
2 184
if true, if not nested if funcion by Cali
Having some trouble figuring out a formula. Hope someone can help! This is going to go into Cell B10. If cell b7 is =equal or greater than the value in B12...
May 24th, 2010 07:15 PM
by Cali Go to last post
2 196
What if scenarios using multiple worksheets by Catalin
Dear Friends Is it possible to have scenarios in XL 2003 across 2 or more worksheets? Which means, for example, I had some chaging cells in one sheet other...
May 24th, 2010 05:57 PM
by Don Guillett[_2_] Go to last post
1 220
Yes - No Fill-ins & More by DisMusBeDaPlaz
Working in Excel, I am looking for help using fill-in boxes. I am creating a form. Setting up a cell or a bunch of cells merged where you can enter a...
May 24th, 2010 04:38 PM
by DisMusBeDaPlaz Go to last post
0 178
Post New Thread


Display Options
Showing threads 341 to 360 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:27 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.