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
Lock a formula to a column of cells by dragons_lair
I have a running balance total but as other users access this form they inadvertently delete the formula or add more rows than have been allowed. I can use...
May 21st, 2009 02:53 AM
by dragons_lair Go to last post
3 93
lookup by amc020781
I use an excel spreadsheet to record numbered boxes that I have in different locations for different customers. However one customer may have 10 different...
May 21st, 2009 01:04 AM
by Ashish Mathur[_2_] Go to last post
2 139
Conditional Formatting by Chris 21222222[_2_]
Is there a way to have a list validation that allows the box to change currencies. For example, if i have a validation stating USD, CAD and I click USD. And...
May 21st, 2009 01:00 AM
by Gord Dibben Go to last post
1 90
Linking to combo box selection by PSM
In workbook "A" the user will type lots or data into various pre-defined cells. They will also use a couple of combo boxes to make selections. In another...
May 21st, 2009 12:57 AM
by Ashish Mathur[_2_] Go to last post
1 84
Vlookup by Cazumel
I have the following situation: Look up M1459 on R1459 how do I build my look up reference matching only the numbers and not the letters. Thank you
May 21st, 2009 12:08 AM
by Max Go to last post
1 84
May 20th, 2009 11:43 PM
by Gord Dibben Go to last post
5 197
Sorting data in one sheet by Gwen
I created a sheet with many columns and rows. I want to be able to sort the data in different columns but keep all of the row information together. For...
May 20th, 2009 11:36 PM
by Gord Dibben Go to last post
4 105
Conditional Replace without macros by Craig
Hi I have a big Excel list with a header row Right now, I do a filter on two of the columns to display only rows that meet both criteria. Then I do an...
May 20th, 2009 11:34 PM
by Gord Dibben Go to last post
2 84
Adance Filter that "CONTAINS" by HeartMom
Hello I need your help. I will warn you now, that I am new here and may not know the EXACT terminology so please bare with me. I am trying to use an...
May 20th, 2009 10:32 PM
by Peo Sjoblom[_3_] Go to last post
1 88
Is there an XLS function to convert std time to Military time? by Carl
Is there an XLS function to convert std time to Military time?
May 20th, 2009 09:48 PM
by David Biddulph Go to last post
1 78
Find occurance of a part number? by Premachine
I have a computer sales program that will output an excel spredsheet that contans all of my computer generated 10 digit part numbers. Part#'s are generated...
May 20th, 2009 09:46 PM
by T. Valko Go to last post
1 71
Principle and interest formula - Help by Scoober
Hi, Can some one help me with the following. I have had this formula working in a spredsheet for a while now and have realsied it has a...
May 20th, 2009 09:08 PM
by Scoober Go to last post
6 98
Automating Inventory data via e-form by Lex
How can I best merge updated data collected via Excel form into existing spreadsheet? Thank you
May 20th, 2009 08:23 PM
by Lex Go to last post
0 104
Merging data from Excel form by Lex
Is it possible to import data collected using an Excel form into an existing Excel spreadsheet? I wish to update an existing Inventory spreadsheet with data...
May 20th, 2009 07:59 PM
by Lex Go to last post
0 80
date and time format by sorab
Hi, I'd appreciate a solution if any to my query. I have entered a date and time in a cell as (9mar09 24:00) The cell is formatted to show date and time and it...
May 20th, 2009 07:49 PM
by sorab Go to last post
2 81
calculating days by Kay
I have a cell with the start date included month, day and year; I have other columns from january to december. I need to allot 3 day evenly per year that is...
May 20th, 2009 07:19 PM
by Kay Go to last post
2 78
I think it is a lookup question??? by LOC
I have a range of numbers - effect sizes AD2:AD47. In another column AP, I want write a formula that will look up the percentile conversion within the same...
May 20th, 2009 07:04 PM
by Sean Timmons Go to last post
3 85
sumif multiple columns by Mona
Thanks in advance! Data A B C D E 1/2/2009 3 1 3 2 1/3/2009 2 5 2 6 1/4/2009 1 3 1 3 If...
May 20th, 2009 06:41 PM
by Jacob Skaria Go to last post
3 82
Pivot table help for excel 2003 by rishi
Hi, I need to create a pivot table in excel 2003 in the following format -: Item SumPrice SumQuantity A 100 20 B 200 ...
May 20th, 2009 06:16 PM
by Roger Govier[_3_] Go to last post
1 77
History of Workbooks opened by derek
Can someone advise me as to how I can see a list of workbooks I used today when I open Excel tomorrow. I used to see a list of workbooks I had used when I...
May 20th, 2009 05:55 PM
by Gary''s Student Go to last post
1 76
Post New Thread


Display Options
Showing threads 10881 to 10900 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 04:55 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.