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
Sum values in one row dependent on a value in a different row by Mike of Tilford
In Row 5 I have 9 cells with the text value of S, W or R, 3 of each - ie S, R, S, W, W, S, R, R, W. This is a random order that changes in each table. In...
September 1st, 2008 07:09 PM
by Mike of Tilford[_2_] Go to last post
4 133
Why is my Excel chart printing as a 1.5 inch rectangle? by Sharnjean
I tried to print one of my spreadsheets from Excel and it printed as a very small rectangle at the top of the page instead of full page.
September 1st, 2008 06:46 PM
by Ragdyer Go to last post
4 189
If function by Andrew
I am trying to get a formula to work for 3 different scenarios. Cell R92 can have 3 outcomes: - If the outcome is 0 the answer should be "Not Completed" - If...
September 1st, 2008 05:31 PM
by Andrew Go to last post
3 107
ME, STRANGE SUMMATION by Berj
Hi, I can have the number 1 in several cells in a range of cells A1 to Z1, but it is always filled starting from cell A1 and gradually to the right. May...
September 1st, 2008 02:55 PM
by Teethless mama Go to last post
3 130
Macro - Whats wrong? by NPell
Whatrs wrong with this?? I either get an error saying no data, or can not be used with multiple selection. Sheets("Data").Select Selection.AutoFilter...
September 1st, 2008 10:51 AM
by NPell Go to last post
4 128
Date Format by TFMR
Dear All, I have time sheet, which have Date and day columns in day column I gave the ref. to A1 and change the format to "DDD", It shows the day e.g. Mon or...
September 1st, 2008 10:33 AM
by Roger Govier[_3_] Go to last post
2 135
Cell Formatting by TFMR
Dear All, I have the time sheet, where one 2nd row is for date, 3rd row for day. 3rd row is equal to 2nd row and I change the the 3rd row to...
September 1st, 2008 08:50 AM
by David Biddulph Go to last post
3 98
Cell formatting by TFMR
September 1st, 2008 08:06 AM
by TFMR Go to last post
0 87
Data Validation Lists by Steve SME
Using Excel 2003, workbook is multi-paged, previous pages have data validation 'in cell dropdown' lists. One page will not show the 'in cell dropdown lists'....
September 1st, 2008 06:25 AM
by Max Go to last post
1 125
Run macro according to value of a cell by Kashyap
How to make a macro run automatically according to a value of a cell? Eq: once we enter value '5' in cell G8, then a particular macro should run 5 times
September 1st, 2008 05:09 AM
by Héctor Miguel Go to last post
1 107
Index/Match or Vlookup by S
I need help to return a cross-reference: Age/Age 20 21 22 23 20 1.25 1.26 1.27 1.28 21 1.15 1.16 1.17 ...
September 1st, 2008 04:21 AM
by Rick Rothstein[_2_] Go to last post
2 130
PUTTING VBA'S TOGETHER by confused deejay
hiya after weeks and weeks of research, questions and many answers i've managed to put an expense sheet together with links and other bits involved the...
September 1st, 2008 03:56 AM
by confused deejay Go to last post
5 112
Row Protection by Freshman
Dear experts, In a worksheet, from A2 to E200 is the range for users to fill in. Each row is an application record and users will fill into it. I will...
September 1st, 2008 03:50 AM
by Freshman Go to last post
2 105
Auto run macro by Esradekan
I have an array (B6:J21) that requires a macro being run (sorting macro) when any figure in the array is changed. How can I run this macro "on demand"??
August 31st, 2008 11:58 PM
by smartin Go to last post
5 180
Is a cell a formula or value? by todd
I'm stumped, I thought there used to be a =isformula to test whether a cell is a formula or not. How can I test for that to see if a formula got overwritten...
August 31st, 2008 11:27 PM
by Harlan Grove[_2_] Go to last post
2 78
Lookup Function Not in Ascending Order by Jessica Donadio
Is there any other way of going about getting the results that the lookup function obtains without the list havng to be in ascending order? I have a pretty...
(Multi-page thread 1 2)
August 31st, 2008 11:04 PM
by Jessica Donadio Go to last post
14 170
Formatting xl cells by Brian of Basildon
Does anyone know if xl cells can be programmed to perform "what" or "what if", "goto", "if", "then" etc -- Brian of Basildon
August 31st, 2008 02:50 PM
by Gord Dibben Go to last post
2 89
How do I auto complete a cell with text from another worksheet? by Mark Barnard
I have a long list of names and associated data contained in one worksheet. On another worksheet, I have created a form that loads the pertinent data...
August 31st, 2008 02:39 PM
by Gord Dibben Go to last post
3 132
sumif maybe? by Esradekan
lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to...
(Multi-page thread 1 2 3 ... Last Page)
August 31st, 2008 01:10 PM
by Don Guillett Go to last post
30 420
How can excel generate every unique pair from a set of numbers? by mistermat
If I have a set of unique numbers, for example: 1 2 3 4 how can i use excel to generate every unique pair automatically in two separate columns, for example:
August 31st, 2008 12:52 PM
by Mike H Go to last post
3 93
Post New Thread


Display Options
Showing threads 20921 to 20940 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 07:35 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.