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
Excel changing date format after VB has run by Richhall[_2_]
Hi I have a sheet 1 with a combo box and a blank field. When something is selected from the combo box a date gets populated in the blank field. The date is...
January 5th, 2010 05:05 PM
by Richhall[_2_] Go to last post
3 102
validation controls in excel by harini 04B01A0503
Can I get a formula fr applyin a validation control on a cell which accepts alphanumeric values with specified text length..its abit urgent fr me..im new to...
January 5th, 2010 04:25 PM
by Bernie Deitrick Go to last post
1 128
Sending data to tabs by Kirk
Hi, Im trying to send data to different tabs. I have sorted the data in column C so the numbers run one after the other. Is there a quick way of sending the...
January 5th, 2010 03:53 PM
by Otto Moehrbach[_2_] Go to last post
2 147
IF & VLOOKUP by Surya Vyas[_2_]
Hi, I need to look up data structure number (for eg: 4) and match the same with structure range from 1 to 6. and if the data structure matches, and it has a...
January 5th, 2010 03:11 PM
by Surya Vyas[_2_] Go to last post
0 92
how do i retrieve the largest value from several records/rows in e by Louis
i'm trying to retrieve the largest value from a field. the records are many but i only want to include the records related to a specific person. "DMAX" seems...
(Multi-page thread 1 2)
January 5th, 2010 02:33 PM
by Max Go to last post
14 232
CHANGE TEXT DATE TO NUMERIC DATE by slf
The following imported data isn't recognized as a dates: Jul 4 2008 6:30AM Jun 22 2007 5:59PM I have tried both of these formulas found elsewhere in the...
January 5th, 2010 11:20 AM
by Stefi[_2_] Go to last post
5 140
looking for a function that hopefully exist by formula_hardrocker
i want to lookup a value in a column on a worksheet and if that value is true i want to take that information in that row and insert it into another...
January 5th, 2010 11:04 AM
by Max Go to last post
1 113
blank cell instead of x by bill gras
I need a formula to have a blank cell instead of a "x" eg: result should be: aa ab...
January 5th, 2010 10:46 AM
by bill gras Go to last post
2 128
I simplify my question about lookup function. by hkgoodwill
I want to use lookup function to search column G of following table (e.g. lookup(28(d)(ii),A3:G90) ). Please note that the first coloumn of the table...
January 5th, 2010 10:33 AM
by hkgoodwill Go to last post
0 104
I simplify my question about lookup function and hope someone can help ? by hkgoodwill
I want to use lookup function to search column G of following table (e.g. lookup(28(d)(ii),A3:G90) ). Please note that the first coloumn of the table...
January 5th, 2010 10:30 AM
by hkgoodwill Go to last post
0 80
Multiple Values by JJ
My next problem is I need to extract only certain information from a worksheet as sample- Worksheet A Worksheet...
January 5th, 2010 09:52 AM
by JJ Go to last post
5 137
Generating random numbers by tobbey
How do i generate random 4 digit numbers using office outlook?
January 5th, 2010 09:05 AM
by Mike Middleton Go to last post
2 86
when setting a cell to equal a blank cell it displays 0 by BWildeRed
If I make cell A1=B1 the result in A1 is 0 (zero) if B1 is blank. Is it possible to have a blank result in A1? I am trying to create a template where I have...
January 5th, 2010 08:04 AM
by T. Valko Go to last post
2 102
Pivot table for worksheet text fields? by Tom Mitrano
Can a pivot table concatenate text that appears in a worksheet? I often use Excel to lay out questionnaire responses. Pivot tables are great to calculate...
January 5th, 2010 08:02 AM
by ryguy7272 Go to last post
2 125
No of Days between two dates and offset formula by vmohan1978
I want to find the no of days b/w two days it should consider saturday as half day holiday and sunday as fully day holiday . and any holidays in that week...
January 5th, 2010 05:57 AM
by vmohan1978 Go to last post
4 109
non-numeric in a calculation by Albert.Harmse[_2_]
I need to calculate hours worked for the employees. The staff reg got the moths dates in row 1, and "time in" and "time out" in row 2. Column A is for all...
January 5th, 2010 05:44 AM
by Fred Smith[_4_] Go to last post
1 107
cell formattiing by Kamron
I have to export a spreadsheet from another data base. The numbers come over as ##-####-##-#, and I am unable to change their format. Does anyone know how...
January 5th, 2010 04:23 AM
by B. R.Ramachandran Go to last post
2 124
Nested IF Statements by [email protected]
Hi, I'm looking to return a result of blank, 1, or -1, depending on the value of another cell. Here's what I have so...
January 5th, 2010 03:54 AM
by T. Valko Go to last post
6 97
Paste Special/Format by Kamron
Whenever I try to paste cell A's format into cell B, the value & format of A gets pasted into B. The same result happens when I use the paint brush...
January 5th, 2010 03:36 AM
by clr Go to last post
1 95
#NAME? Error With User Defined Functions by Thomas M.
Excel 2007 I have a problem that has been driving me nuts. I created a code module and have pasted a couple of user defined functions into the module. When...
January 5th, 2010 02:39 AM
by Gord Dibben Go to last post
7 176
Post New Thread


Display Options
Showing threads 4161 to 4180 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 12:42 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.