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 Reverse Sort Order Last Post Replies Views
HOW MANY "/" IN THIS CELL A1 = "RG/351/87/11/3" by - - - - -
hi, i want to calculate the following; CELL A1 HAS A VALUE = RG/351/87/11/3 1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL 2- HOW MANY "3" (THREE) IN...
February 12th, 2007 12:26 PM
by mike Go to last post
4 39
Auto update information in footer by - pat
Hey, I would like to ad a feature in an Excel footer that would place a person's information(login name, identifier, etc.) for when the file was created...
February 11th, 2010 08:15 PM
by - pat Go to last post
0 70
Drop down box issue by - pat
Hey all, I am using excel 2007 on XP Professional SP2. I am using a drop down box on a worksheet that selects from a column of designated data elsewhere on...
February 11th, 2010 01:18 AM
by Ashish Mathur[_2_] Go to last post
2 114
Converting Time by ---Francis---
Hello, I am using MS Excel 2000. I have a cell that displays a number in seconds. The number is rather large and it would be useless to show this time in...
June 7th, 2004 06:53 PM
by Francis Go to last post
2 73
convert second to date and time by --== Alain ==--
Hi, i've got some exported log from unix platform. in those logs, time and date is written as lapsed second since 01.01.1970. How can i extract date and time...
December 8th, 2006 11:19 AM
by Bob Phillips Go to last post
4 47
Link cells with text not numbers by --Viewpoint
I'm working with a worksheet of cells with general information (text) that I linked to various cells on worksheets within a workbook. I created the formula...
February 6th, 2010 02:19 AM
by --Viewpoint Go to last post
4 99
Time Calculation and formulas needed (2 questions) by --Viewpoint
#1 I'm creating a time sheet and set it up for time in and out to have separate cells using the h:mm AM/PM format. In a separate cell I have amount of time...
January 27th, 2010 09:43 PM
by Teethless mama Go to last post
1 49
How to retain part of formula's criteria as static by --Viewpoint
Below is a formula that I want A50:A100046 to remain static so when I "fill down" the information doesn't change. ...
May 21st, 2010 07:53 PM
by --Viewpoint Go to last post
7 205
OT I would want protect my sheets of excel from a "password recovery" software... How? by -= Luca =-
I would want protect my sheets of excel from a "password recovery" software... How? I would want protect my sheets of excel, I do not want that mine...
May 31st, 2006 10:11 AM
by macropod Go to last post
3 85
The same IF (SE) formula give me two different number: why??? by -= Luca =-
The same IF (SE) formula give me two different number: why??? Hi, please help me to understund why this formula it wrong download this (45kb) Your download...
June 30th, 2006 01:30 PM
by Dave Peterson Go to last post
5 82
Trying to import several million rows- help! by -=Drew
All- I have a gigantic file that I need to do some data mining into. It's about 70,000 pages of flat data records (my best guess- haven't made it to...
August 9th, 2004 07:33 AM
by Alan Go to last post
9 94
diverting output by -az
hello, how do i make a function in one cell alter the value of another cell? i would like to do the following: if cell1 equals "test string" then make cell(3...
February 24th, 2006 01:53 AM
by Dave Peterson Go to last post
1 49
Need to find the right-most cell value in a string of cells by -dc-
In a row of Excel cells, I am wanting to print the last cell. For example A1=2, A2=55, A3=9. I would like to create a formula within a cell that displays 9...
March 8th, 2005 08:28 PM
by Domenic Go to last post
2 98
COMBO BOX FOCUS by -debi-[_2_]
Is there a way to get to a Combo Box without using the mouse? The user wants to enter data, but use the tab or enter key to move through the sheet and not...
July 18th, 2008 03:07 PM
by -debi-[_2_] Go to last post
0 60
using vlookup help by -keevill-[_3_]
Every few weeks I get an excel sheet which consists of several columns of items. The first column is the name of the complete item and across the sheet each...
June 5th, 2008 09:24 AM
by Bob Phillips Go to last post
1 57
MONTHNAME when getting external data from Access by -PJ
I have a query in MS Access that uses the monthname function. When I try to create a pivot table from external data (using the DB as the source) I get...
June 30th, 2006 08:50 PM
by FxM Go to last post
2 39
How do I reference a cell as PART of a vlookup "Table_Array" locat by -Rocket
Basically, I have a matrix, and the top axis is the same as the name of other pages in my workbook. The left axis are components that are on multiple pages...
January 4th, 2007 04:49 PM
by -Rocket Go to last post
2 39
calculated celles according to more then 1 condition by -yuval[_2_]
Col B = name (text field) Col C = Last name (text field) Col D = Expences (number) I would like to SUM to A1 total expences of a person (True on 2 conditions...
February 6th, 2009 06:42 PM
by xlmate Go to last post
5 44
link text cells on different sheets by ...jay...
I have text from one worksheet that I want to link to another worksheet, but I don’t know how to do it. To give you a better idea, on the first sheet I have...
September 29th, 2008 09:09 PM
by Peo Sjoblom[_2_] Go to last post
3 82
Solar cells for less than 1 USD per Watt by ..[_2_]
Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.
February 10th, 2010 09:28 PM
by ..[_2_] Go to last post
0 73
Post New Thread


Display Options
Showing threads 361 to 380 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:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright ©2004-2018 OfficeFrustration.
The comments are property of their posters.