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 Replies Reverse Sort Order Views
removing alpha by MBD
I have a cells that have numbers and alphas...for example, 1A, 1B, 1C.....in order to join this table to a corresponding table in GIS, I need to remove the...
(Multi-page thread 1 2 3)
June 5th, 2007 01:06 PM
by Ron Rosenfeld Go to last post
23 246
another IF query ...... by englishrose4719
How do I work this one out please? IF 'A20' is not null AND 'A16' is null OR 'A17' is null then COUNT result in 'A14' on a different spreadsheet!!!!! help...
(Multi-page thread 1 2 3)
May 18th, 2007 11:03 AM
by CLR Go to last post
23 245
sumproduct!!! by nowfal
Hi, In the first sheet, i have the following...
(Multi-page thread 1 2 3)
September 28th, 2004 09:00 PM
by Dave Peterson Go to last post
22 307
How to determine the angle within hexagonal spiral? by Eric
Creating a hexagonal spiral around 0, 1 will be inserted in 60 deg, 2 will be inserted in 120 deg, 3 will be inserted in 180 deg, 4 will be inserted in 240...
(Multi-page thread 1 2 3)
December 31st, 2007 11:41 AM
by Sandy Mann Go to last post
22 247
my impressions of Excel 2007 by T. Valko
I finally broke down and installed Excel 2007... The ribbon isn't horrible but it'll take some getting used to. Kind of reminds me of a video game. I've...
(Multi-page thread 1 2 3)
January 28th, 2008 08:07 PM
by Ron de Bruin Go to last post
22 197
sumif with 3 condition - urgent by RKS
Hi all I have protect excel sheet1, which we have enter data in many column. I have create another sheet2 for summery. here we have use 2 criteria like...
(Multi-page thread 1 2 3)
March 29th, 2008 01:02 PM
by Don Guillett Go to last post
22 180
Determining a leap year by ARGT
I want to calculate a daily interest rate from an annual rate. I have input the following formula into a cell labelled "Days in the Current Year" :...
(Multi-page thread 1 2 3)
July 1st, 2008 01:27 AM
by Rick Rothstein \(MVP - VB\)[_800_] Go to last post
22 322
Getting cell index from cell to the right by Pontus
Hi, I want to have a formula that retrievs the index from the cell to the right of the cell with the formula. I know that the formula below gives the index...
(Multi-page thread 1 2 3)
July 10th, 2008 04:17 PM
by RagDyeR Go to last post
22 262
time format by art
Hello: I have the vba code below but I need some changes. I want to make that when I enter in a cell 5a it should automatically format it to 5:00 AM and when...
(Multi-page thread 1 2 3)
September 24th, 2008 05:17 PM
by Rick Rothstein[_2_] Go to last post
22 176
Formula required. by sherbrooke[_2_]
I have rows of figures over a number of columns, starting at column A, with totals for each row in column K. I then want to allocate values from 1 to 8 to...
(Multi-page thread 1 2 3)
January 26th, 2009 08:21 PM
by sherbrooke[_2_] Go to last post
22 199
Can I Make This Computation Shorter? by Steve[_29_]
I have a column (A) of stock prices. In the next column I copy down the formula: =(A7/(MAX($A$5:A7))-1)^2 all the way to =(A57/(MAX($A$5:A57))-1)^2 I then...
(Multi-page thread 1 2 3)
October 28th, 2007 09:11 PM
by Sandy Mann Go to last post
22 182
Moved files and can't find them by Irene
I moved all of my related 2006 files/folders to a single folder "2006". Now when I go into this "2006" folder that has all of my work for last year I get an...
(Multi-page thread 1 2 3)
November 1st, 2007 07:38 PM
by Dave Peterson Go to last post
22 177
$ - 0.00 nevgative zero by Michele
for some reason my formulas are returning a $ -0.00 instead of $0.00 like it has always done before. How on earth do i have a negative zero. Zero is...
(Multi-page thread 1 2 3)
June 19th, 2007 01:59 AM
by Jerry W. Lewis Go to last post
22 302
data gets rounded up !!! by Dr Alok Modi MD
I have devised a workbook where I enter the credit card details of the transactions received at my hospital for people who pay by credit card. In this there...
(Multi-page thread 1 2 3)
December 16th, 2008 01:44 AM
by Ron Rosenfeld Go to last post
22 181
Merged cells won't Autofit row height by Hpyifur
When I merge cells and then choose the wrap text option the Autofit function no longer works. Is there a way to get around this without manually sizing the...
(Multi-page thread 1 2 3)
July 20th, 2009 10:43 PM
by Jeno Go to last post
22 547
Help - Daughter by newbie
My daughter is taking an excel class - she needs help with this story problem - can anyone assist us on getting her started. Manager of furniture store is...
(Multi-page thread 1 2 3)
January 2nd, 2007 05:21 PM
by Curt Go to last post
22 542
Excel Sorting help by [email protected]
I hope someone can help me with this as simply as possible. I would prefer to stay away from VB (don't know how to use it very well), but I will do what I...
(Multi-page thread 1 2 3)
September 9th, 2006 01:04 AM
by Max Go to last post
22 172
How do I change the case from all caps to proper for names I have in columns E, F, G? by duugg
:confused: I know that a formula would work, but I don't know what it is and more importantly, where to put it. In other words, if the "all caps name" is in...
(Multi-page thread 1 2 3)
April 26th, 2006 01:25 PM
by duugg Go to last post
22 375
Macro for hiding rows by Luke
I have a spreadsheet which contains a lot of rows with no data, I would like to create a macro to hide these rows. Preferably I would like it to work off one...
(Multi-page thread 1 2 3)
December 24th, 2005 04:40 PM
by KL Go to last post
22 321
copy multiple records based on criteria or total amount by David
Hi everyone, I have a worksheet with over 20000 records, i did a dcount based on amounts from 500-5000 and i got a result of 250 records, and dsum based on...
(Multi-page thread 1 2 3)
July 29th, 2009 10:58 PM
by Joel Go to last post
22 270
Post New Thread


Display Options
Showing threads 101 to 120 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 11:34 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.