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
Countif by jay
I have two worksheets. I would like to have a formula that counts data according to the following conditions. Worksheet 1 A B ...
May 28th, 2010 03:21 AM
by jay Go to last post
3 222
SUMPRODUCT WITH 4 CONDITIONS NOT WORKING by Carrach
My formulae below is not working, can you help? Column H contains 'NZ' or 'SZ', column I is in 20/5/2010 format, column G contains 'trade' or 'fdi', Column...
May 28th, 2010 03:07 AM
by T. Valko Go to last post
3 542
bank transfer error numbers display from workbook to csv by Tia[_3_]
Dear all, I have a an excel file 99-2003 workbook that includes bank code and salary details, it is required from me to save it as csv but when i do so all...
May 28th, 2010 03:01 AM
by Fred Smith[_4_] Go to last post
1 295
If greater than 5 by Carolan
Need a formula - I know it's simply - just can't get it. If A1 is greater than 5, then B1 = 5 If A1 is less than 5, B1 should equal the amount in A1 CarolAnn
May 28th, 2010 03:00 AM
by T. Valko Go to last post
4 239
Average IF's by Noodnutt @ Work
Hi Guy's Can anyone help me out with the 2K version of the following plz. =IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)) This works...
May 28th, 2010 02:55 AM
by Fred Smith[_4_] Go to last post
4 309
How do I preserve font/size when sending text to a different cell by Robert
I am making a template for a restaurant menu and have the complete menu listed on the page. The menu I am creating is on the same page and would allow me to...
May 28th, 2010 02:18 AM
by Gord Dibben Go to last post
1 263
RANDBETWEEN INSTALL by ALee
On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions...
May 28th, 2010 02:17 AM
by Mike Middleton[_2_] Go to last post
7 414
Formula to display nearest following Thursday in mm/dd/yyyy format by BW
Hello, I have been reading and trying different suggestions here to no avail. What I need is a formula to calculate the nearest following thursday, and...
May 28th, 2010 02:07 AM
by T. Valko Go to last post
1 307
Count digits before decimals and after decimals by Elton Law[_2_]
Dear expert, Would like to count the digits before decimals and after decimals. For example, 111975.35 should be 6 digits before decimals and 2 digits...
May 28th, 2010 01:42 AM
by Ron Rosenfeld Go to last post
4 341
sales tax chart by momof5
I know there must be a formula to figure this out easily, but I can't do it. I am trying to make a chart like the illustration without figuring every line....
May 28th, 2010 01:17 AM
by momof5 Go to last post
0 247
One step paste of XLS file name in one of its own cells by SeeThomas
Is there a way to automatically paste the file name of an open excel file into one of its own cells. I can paste the file name of a Word Document with a...
May 28th, 2010 01:11 AM
by Dave Peterson Go to last post
2 348
Convert Week number to Month by KT
I have a worksheet with year and week number and want to use a funtion to convert these two values into the descriptive month. Some weeks cross months, but...
May 28th, 2010 12:48 AM
by KT Go to last post
0 312
Search, Match, Pull by sjkoep
Hello, I am looking for help to: Search through two columns (one for employee, the other for employee number). I want it to match those two criteria and...
May 28th, 2010 12:35 AM
by Max Go to last post
1 208
Multiple Numbers in a cell by Booj
I have a worksheet that has multiple numbers (1234, 3425, 34234,etc.) in a single cell. I need to separate these and create a new row for each one (ie. A1...
May 28th, 2010 12:21 AM
by Don Guillett[_2_] Go to last post
2 266
VLookup by Mary Lou
I have a workbook with two worksheets. On the first - it has the following columns: Inv # Employee Fees Paid on the second worksheet i have the...
May 28th, 2010 12:20 AM
by Don Guillett[_2_] Go to last post
1 198
Macro to select last row by msnyc07
I am trying to automate putting a sheet value into Row I. My manual method is to paste the formula in I2 (since values begin on Row 2), then go to A2, Ctrl...
May 28th, 2010 12:19 AM
by Don Guillett[_2_] Go to last post
1 337
I type in a number in a cell but it wont convert to currency help by Out in VA
I copied and pasted a worksheet from old version of excel into the new 2007 and when I type a number in a cell and try to convert it to currency --_NOTHING...
May 28th, 2010 12:04 AM
by Otto Moehrbach[_2_] Go to last post
2 303
Excel - Convert int value secs past midnight into time 53100=2:45 by Zuly
How do convert an int value of seconds past midnight into a time value? Example: 53100 = 2:45PM
May 27th, 2010 11:49 PM
by Fred Smith[_4_] Go to last post
1 323
Picture protection by Suresh Lohar
when we protect a sheet with a password, why a picture that we insert in sheet is not protected. Suresh
May 27th, 2010 11:49 PM
by Tom Hutchins Go to last post
1 284
May 27th, 2010 11:45 PM
by Fred Smith[_4_] Go to last post
1 278
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 09:56 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.