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
Logical function please by Amin
Hi i have an inventory table where a column is to remind me of reordering but my approach is not helping me so i need a help. i have a column in a...
April 16th, 2010 09:44 AM
by Amin Go to last post
3 135
Pulling a cell reference--clickable cells? by Bermie
Hello: I have a problem to which I'm sure there is a solution, but I haven't been able to find it yet: I have a master list of different employees' ratings...
April 16th, 2010 09:33 AM
by Steve Dunn Go to last post
1 177
creating a report from a table, pivot table not suitable by UKMAN
hi I have data table with 7 headings, the cell of each row contains a project code and there are multipule project codes. By means of a drop down list (list...
April 16th, 2010 08:35 AM
by Steve Dunn Go to last post
1 130
Function similar to "LEFT" by Karen D
I'm trying to separate the last name from the first name in a field. I can get the first name by using the "left" function. Does anyone know how to get the...
April 16th, 2010 06:28 AM
by Jacob Skaria Go to last post
2 141
copy formula by Jafferi[_2_]
In Sheet a, i have these info Employee Number hiring date 122555 apr 5, 2010 152666 apr 4, 2010 123554 apr...
April 16th, 2010 06:19 AM
by Jacob Skaria Go to last post
3 213
CONCATENATE by Tservo
I would LOVE to combine cells from the same column instead of cut & pasting information. - example D132 through D147 and have this combined information...
April 16th, 2010 02:54 AM
by Ashish Mathur[_2_] Go to last post
3 144
SUM by Talladega
Hi, I have a few hundred rows. Each row contains a person information and amount. There are multiple rows with the same person, but different amount. I...
April 16th, 2010 02:47 AM
by Ashish Mathur[_2_] Go to last post
2 123
Pivot table show all days of a month even if no data by Elan lent
Hello, My question is the following. If i have data based on date (days). How to show all the days of the month even if there is no data for some days in the...
April 16th, 2010 02:30 AM
by Herbert Seidenberg Go to last post
2 230
Conditional Formatting Date Range by BWR_Rick
Excel 2003 I enter a series of dates in B3:B13 - Cells formatted as dates I have a mini calendar in Q7:W12- Cells formatted as dates, but only showing date...
April 16th, 2010 02:25 AM
by T. Valko Go to last post
1 152
VLOOKUP returning formula by Jan Ogg[_2_]
I have a VLOOKUP on one worksheet =VLOOKUP(A1,'Tasks'!A1:C17,2,FALSE) which refers to looking up the 2nd column of the reference A1 on the sheet that the...
April 16th, 2010 02:12 AM
by T. Valko Go to last post
3 167
copy/paste malfunction by Innovator
I use the copy command to copy a line. The process locks up with a jagged line around the copied phrase. I waite for 15-20 seconds then it unlocks and I am...
April 15th, 2010 11:26 PM
by Innovator Go to last post
0 116
VLOOKUP & IF by Sarah
Hi All, I am looking to use an if statement with 2 separate vlookups. Is this possible? Basically what I want to do is if B3=PWRFUT then...
April 15th, 2010 11:14 PM
by T. Valko Go to last post
9 172
spreadsheet by Ben Rivera
I have one spreadsheet with 2 worksheets (A and B). Is there any way to setup a formula that will copy text input into B from A? Thanx
April 15th, 2010 10:55 PM
by CLR Go to last post
1 120
Need function to return numbers at beginning of text by Nadine
I have a column of cells that contain an id and description in one column. I need a formula that will give me only the id. The id can be either 4 or 5...
April 15th, 2010 10:30 PM
by T. Valko Go to last post
2 135
Can excel data be encrypted? by Confused
I have Employee numbers that I want to encrypt so the employees cant be identified. Can this be done in excel and how? Thank you.
April 15th, 2010 09:58 PM
by Joe User[_2_] Go to last post
1 167
Standard deviation and bell curve by Meebers[_4_]
I have a long list (1400) of patient check in's and registration completion by time formated as 13:30. I am trying to find the standard deviation and...
April 15th, 2010 08:41 PM
by Meebers[_4_] Go to last post
0 142
rounded # to correct # by Wagnerk
I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I use to get the real number which is 12.85? Please Help!
April 15th, 2010 08:29 PM
by David Biddulph Go to last post
4 146
Add values based on text color with the criteria of a date by Peter Gonzalez[_2_]
I have some data that I gather up every day. This data concerns of Parts, Quantities and work orders numbers. The parts have to be divided by departments...
April 15th, 2010 08:16 PM
by Peter Gonzalez[_2_] Go to last post
7 135
Add no. of days to a workday to get new workday? by blswes
Looking for a formula so I can add a number of workdays to an existing date to get the new workday (i.e. existing date + workdays = new workday). Here's an...
April 15th, 2010 07:39 PM
by Duke Carey Go to last post
1 133
Compare 1 cell to column of cells returning adjacent cells info? by Mr. Fine
I want to compare the value in one cell to another column of cells in another work sheet and once the matching value is found I wan to return a different...
April 15th, 2010 07:36 PM
by Duke Carey Go to last post
1 132
Post New Thread


Display Options
Showing threads 1241 to 1260 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 02:44 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.