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
Indirect formulas in cells not holding cell format after copy by Cathy[_6_]
Hello. I have a bunch of indirect forumlas in cells that are taking values from another open workbook. I use the copy and pastespecial method to get the...
March 21st, 2010 06:39 AM
by David Biddulph Go to last post
3 148
Use CountIf for a literal string by chadkwelch
I am trying to count the number of cells in a range that contain the string 0.1. I don't want the number of cells that contain numbers less than 0.1, I want...
March 21st, 2010 04:45 AM
by Ashish Mathur[_2_] Go to last post
3 206
salary defined by slab table by XKruodo
Hi, I have a sheet with a table which has number of hours in a column A. Salary per hour is in column B as under. 50 3.5 100 5.7 150 ...
March 21st, 2010 04:08 AM
by Ashish Mathur[_2_] Go to last post
5 210
Moving cell formula by iamjbunni
I have a formula that calculates averages each week. I need a formula that automatically uses the cell below when new data is entered.
March 21st, 2010 03:58 AM
by Ashish Mathur[_2_] Go to last post
3 152
How to return to the previous active sheet after hyperlink? by Terry
I have many sheets have hyperlinked into 1 common worksheet. How can I return back to the original sheet after click the hyperlink and navigated to the common...
March 21st, 2010 03:53 AM
by Ashish Mathur[_2_] Go to last post
5 162
Data Validation, Identify Duplicates and Limit imput by Lilyput
I have a sheet where I have a reference number in Col D that is comprised of 3 letters, a space then 3, 4, 5 or 6 digits.. I need to identify duplicate...
March 21st, 2010 03:41 AM
by Ashish Mathur[_2_] Go to last post
9 238
Help with conditional formatting... by Mr. Ruger
This may sound like a basic question. But I am trying to set up some conditional formatting based on varying text in Excel 2003. I am sorting baseball...
March 21st, 2010 03:19 AM
by Mr. Ruger Go to last post
0 135
Warning when in another cell after entering a formula. by Ephraim
I find this rather confusing: Cell M7 =IF(SUM(H7:L7)=0,"",SUM(H7:L7)) Cell M8 =IF(COUNTIF(H8:L8,"W")1,"",COUNTIF(H8:L8,"W")) Cell...
March 21st, 2010 02:20 AM
by Joe User[_2_] Go to last post
2 155
calculate a date, 10 weeks after a set date & return a specific da by Art3277
I would like to calculate a date, 10 weeks after a set date and return the date of that tenth week monday? Is this possible.
March 21st, 2010 12:01 AM
by T. Valko Go to last post
2 114
comparing two colums ? countif by manfred3
Hi, I have a spreadsheet with "weeks in column A and "Daily Charges" in column R. col A col R Week 1 Week 1 20
March 20th, 2010 10:16 PM
by T. Valko Go to last post
1 117
Validate data but then change the entry to upper case by Ephraim
Hi, Is it possible to validate data to allow only W, w, L, l and then convert the lower case entry to upper case? I don't want the user to have to keep...
March 20th, 2010 07:04 PM
by Gord Dibben Go to last post
4 167
Help to display chosen columns and rows by Ephraim
My spreadsheed has columns where 6 cells are formatted with text alignment "Center across selection" for Weeks 1 to 30. H1 I1 J1 K1 L1 M1 ...
March 20th, 2010 06:57 PM
by Don Guillett[_2_] Go to last post
1 138
Variable Labor percentage based off of fixed sales +/- by Herbert Seidenberg
Excel 2007 Data Table http://www.mediafire.com/file/w2omdzdz2yy/03_20_10.xlsx Pdf preview: http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_20_10.pdf
March 20th, 2010 05:32 PM
by Herbert Seidenberg Go to last post
0 221
wildacrds by Dave
Hi, XL2003. Is it possible to use wildcards in simple logic statements? If A1 contains "qwerty" and B1 contains "qw" In C1 I've tried: =A1=B1* - xl...
March 20th, 2010 04:48 PM
by G Ray Go to last post
4 160
Multiple sheet querries by G Ray
I want to bring a lot of data into Excel from a database. Using SQL I can retreive much more data than one worksheet can hold. I have found I can create and...
March 20th, 2010 04:36 PM
by G Ray Go to last post
4 123
Excel Logical IF function by Stuck!
I am trying to enter in a function in Excel that if is if A5 is less than half of D5, if true Y if false N. I can not figure out how to enter the half of D5...
March 20th, 2010 10:26 AM
by Fred Smith[_4_] Go to last post
2 125
vlookup function returning "na" even though the vlaues are present by VKL Narayanan[_2_]
i am using a simple vlookup function =vlookup(A13,$B$38..$C$76,2,False) Even though there is correct value for A13 in the array table defined, it is...
March 20th, 2010 10:25 AM
by Fred Smith[_4_] Go to last post
2 126
Trying to collapse a table, what Function should I use? by Brad E.
I have a table of data (numbers) which is 70 rows by 21 columns, which I would like to summarize into a 5 x 3 table. So every 14 rows by 7 columns sums into...
March 20th, 2010 10:10 AM
by excelent Go to last post
3 157
formula to a minimum value of zero if a negative number by Jay M 0425[_2_]
I need help with a formula: if C1-C2 = a negative number I need it to equal zero and not the negative number. How do I do this? It is probably really simple...
March 20th, 2010 05:19 AM
by T. Valko Go to last post
2 181
Counting formula by lawhawg
I need a formula to sum on the cells that match a variable in another cell A B C D E F G H I 1 2 Bo Jim Ron 3 ...
March 20th, 2010 04:15 AM
by T. Valko Go to last post
1 113
Post New Thread


Display Options
Showing threads 1941 to 1960 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 08:20 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.