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
LOOKUP or Offeset by SFrick
I did an earlier post but I guess I was not clear enough in what I need in a formula. In cols J through Z rows 6 through 81 is data. Row 6, J through Z are...
September 17th, 2003 03:55 PM
by Will Go to last post
1 349
barcoding by Kevin
Please help. I have added a font to windows to barcode documents. This font requires an asterisk before and after the value to be scanned. The value I am...
September 17th, 2003 03:47 PM
by L. Howard Kittle Go to last post
1 340
Personal.xls by Frances
I believe I should have a workbook called "Personal", which I understand would hold global macros. The equivalent of Normal.dot in word. Where is mine? Frances
September 17th, 2003 02:59 PM
by Frances Go to last post
3 312
multiple AND conditions with IF's by David
I have to create a column that shows traffic movement data. I'm not really used to Excel and this is the formula I have come up with thus...
September 17th, 2003 02:32 PM
by Jason Morin Go to last post
2 509
last value in a row by Cees Bruin
there probably is a fuction which will give me the last value in a row, the thing is I dont know which one, i use the max value .. but there could be a problem...
September 17th, 2003 02:24 PM
by Jason Morin Go to last post
3 380
DATE by Gary Reynolds
What function returns the date that never updates; stays the same?
September 17th, 2003 02:23 PM
by Andy B Go to last post
1 319
Counting Rows by Buster
I tried to create a function to count rows used on a worksheet and recieved an Overflow(Error 6) message. Public Function UsedRange() Dim MyRowCount As...
September 17th, 2003 02:05 PM
by Bob Phillips Go to last post
1 375
Table Formula by user21
Thank you very much. It was very helpful. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post...
September 17th, 2003 02:04 PM
by Max Go to last post
1 417
concatenate question by jr
I would like to concatenate some cells where the result will be the first letter of one cell and the whole word of the second cell. John + Smith = jsmith. Is...
September 17th, 2003 02:03 PM
by Bob Phillips Go to last post
1 283
multiple field returns by Ian P
I have a list of around 1000 names, separated into first name in one cell, and surname in the next, with an employee number in the third. I need to create a...
September 17th, 2003 02:00 PM
by Peo Sjoblom Go to last post
1 457
generating random numbers by Roger
Is there a way (or formula) to generate a random number in a cell? If so, can I specify the range I want the random number to fall into, e.g., 1 through 6, 0...
September 17th, 2003 01:48 PM
by Roger Go to last post
2 513
Using Sheet Name In Cells by Paul Moles
In Excel Xp how do I get a cell to show the sheet name,alternatively can I get the sheet name to show the contents of a cell.
September 17th, 2003 01:43 PM
by Bob Phillips Go to last post
2 297
Date Format problem by Nishant
Dear All, Please suggest me the solution of my problem, as i m handling data for 60,000 in no.Some body in data entry has enter the date in a cell in gernal...
September 17th, 2003 01:21 PM
by Ron Rosenfeld Go to last post
2 491
Change in time where text is involved by Jill
I am working on a report where I am trying to show the amount of time that passed between when we received a completed contract and when the installlation...
September 17th, 2003 12:43 PM
by Michael Go to last post
1 685
Macros in XP vs 2000 by Peter
Having created a macro in a spreadsheet using Windows Office Excel XP, I send it via email to my office, to continue working on it, & macro will not run (at...
September 17th, 2003 12:43 PM
by Harald Staff Go to last post
1 277
cell to change colour at given date - how to by Tobit
Ken- thanks for solving my original problem. One follow up question. If I put a standard formula in A1 say =A2+B2, I can drag that to the cells below and it...
September 17th, 2003 12:20 PM
by Tobit Go to last post
2 738
combined cell by bayanbaru
I have a huge file but with only 2 column. Column A is the serial number and column B is description. I need to combined the all description that has the same...
September 17th, 2003 12:16 PM
by Debra Dalgleish Go to last post
1 321
lookup formulas by Marian
I have a lookup formula working just fine as long as what I want it to look up is there. My problem is that when the number I want it to look for is not on...
September 17th, 2003 12:06 PM
by barb Go to last post
2 341
Sharing Workbooks by Tim Hagedorn
I have a pretty elaborate workbook set up that is keeping track of my inventory, sales, production, etc.... My problem is that I share this workbook w/ 2 of...
September 17th, 2003 11:58 AM
by BARB Go to last post
2 355
AutoFill On Inserted Rows by Aman
When inserting rows, is there a way to autofill data from the row above or below? I have a simple autosum formula on each row -- if I insert another row, I'd...
September 17th, 2003 10:25 AM
by Andy Brown Go to last post
1 345
Post New Thread


Display Options
Showing threads 87621 to 87640 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 09:44 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.