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 Reverse Sort Order Replies Views
Excel Help Please quick question by Tom Jacques
i want to have a cell automatically fill its self in when another cell says a certain thing. eg - if i type "blue" into D5 i want D6 to automatically change...
November 15th, 2009 07:56 PM
by Gord Dibben Go to last post
7 286
min,average0 if 52 cells read zero by Mike
I have 52 cells w265 that all read zero until data is entered this means one cell in each worksheet example Week 1 w265, week 2 w265, week 3 w265 to week 52...
November 15th, 2009 07:31 PM
by Gary''s Student Go to last post
2 208
return the row of any selected cell by kim55
I want to be able to see in a cell the row number of any other currently selected cell.
November 15th, 2009 07:29 PM
by Gord Dibben Go to last post
3 280
Non reciprocal formula? by Tuk
Hi, can anyone help with this? I need formulae which demonstrate a flow in one direction. I'll put it a simply as I can. I want to be able to add manually, a...
November 15th, 2009 07:18 PM
by Otto Moehrbach[_2_] Go to last post
1 231
Combining 2 Tables Dynamically into third new Table by Carl S.
Below is data from two tables. How to I combine them dynamically, while at the same time selecting records that belong to customer CARL? I am familiar with...
November 15th, 2009 07:09 PM
by Herbert Seidenberg Go to last post
1 382
Excel's localization of scientific notation by Greg Lovern
Does Excel use "E+" and "E-" for scientific notation for all locales? Or are there some locales for which it uses different characters? Thanks, Greg
November 15th, 2009 06:06 PM
by Niek Otten Go to last post
1 278
How do I add more ranges to the following formula? by neivamj
(for Excel 2003) I've a Yearly calendar and a table with around 27 diferent date ranges for 2 teams (alternating). I want the days in the calendar to change...
November 15th, 2009 05:30 PM
by T. Valko Go to last post
3 306
I need to find the sum of the best of 6 scores. by okracerx
I need to be able to calculate the sum of, "the best of 6". Here is an example: Andy Harris 60 54 48 38 60 60 60 22 34 Total is 342 Would like a...
November 15th, 2009 04:25 PM
by Don Guillett Go to last post
8 286
HELP WINDOW PROBLEM by MrBill
Hi.. when I open help, it seems that it makes my work window collapse so I cannot fix the problem I am researching. Since I re-installed office, I cannot...
November 15th, 2009 02:54 PM
by MrBill Go to last post
0 254
putting a column of names into alphabetical order by ElGordo
I have collected data with names against dates and treatments and wish to rearrange the spreadshett into alphabetical order by name. Some names have spaces...
November 15th, 2009 01:41 PM
by JLatham Go to last post
1 240
Indirect function countif by puiuluipui
Hi, i have a number in "C5" and i need to search for this number in another workbook. I need to search only in column C:C. But i need an indirect function...
(Multi-page thread 1 2)
November 15th, 2009 12:26 PM
by muddan madhu Go to last post
11 445
How do I convert US date with 12hr format to European date 24hr by Enda K
I am using Excel. I have a mix of 24hr and 12hr AM/PM format pulling from a database. I want to reformat all dates with time to the 24hr clock so that I can...
November 15th, 2009 10:59 AM
by David Biddulph Go to last post
1 298
Changing the screen tip on a custom button, Name change does not w by kxxxk
I have a number of custom buttons assigned to macros in Excel 2003 SP3, developed over the years. In every one but one, the screen tip that displays when...
November 15th, 2009 07:08 AM
by kxxxk Go to last post
0 269
How do I get SQL data to show CRLF instead of question marks? by Number2
When I query my SQL database from Excel (currently 2007) I have some fields that have carriage-return-line-feed characters and tab characters. These show as...
November 15th, 2009 06:15 AM
by Number2 Go to last post
0 276
need help in formula by kyoko
i really need help for this one: A B C oct 27 -50 cover oct 27 -50 not cover oct 27 50 cover oct 28 150 cover oct 28 ...
(Multi-page thread 1 2)
November 15th, 2009 04:13 AM
by T. Valko Go to last post
10 325
Vlookup only the last 6 characters by JoeP
I have a spreadsheet starting in cell A4. I want to lookup only the last 6 digits in column A and then lookup the value in column J and return the...
November 15th, 2009 01:47 AM
by JoeP Go to last post
2 192
How do I display a 'tick' on excel 2007? by Hard Working
How do I set up my keyboard or what options do I activate to display a 'tick' symbol on Excel (2007 version)?
November 15th, 2009 12:41 AM
by Gary''s Student Go to last post
1 236
VLOOKUP Question by OverMyHead
I feel stupid but I cant figure out what is wrong with my forumla. It will only return #N/A. Here is the...
November 15th, 2009 12:18 AM
by Max Go to last post
3 191
Superscript in Custom Format by Emece
I want to do a custom format that includes Km2, with the 2 as a superscript. First I write it down in a cell and set the 2 to be a superscript. Eventhough in...
November 14th, 2009 11:09 PM
by Gord Dibben Go to last post
2 236
Indirect by puiuluipui
Hi, can this code be made to work with more than one sheet? =IF(SUMPRODUCT(COUNTIF(INDIRECT(""&"LUNI!$C:$C"),C5))0,"YES","NO") -sheets : LUNI ; MARTI ;...
November 14th, 2009 10:47 PM
by puiuluipui Go to last post
2 225
Post New Thread


Display Options
Showing threads 9981 to 10000 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:10 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.