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
matching & combining data from seperate worksheets by sshaefer
Hi, I am working on a data import and need to get the opportunity name from one data source into the appropriate row to matching shipments from another data...
May 10th, 2010 02:47 PM
by Don Guillett[_2_] Go to last post
2 161
MS office 2003 by rajan3389
I had encrypted mt files when I had MS office 2003. Now since I've changed it to MS office 2007 I'am unable to decrypt the files. WHat should I do?
May 10th, 2010 01:53 PM
by rajan3389 Go to last post
0 97
May 10th, 2010 01:37 PM
by John Go to last post
1 140
custom format changes to special by Jan S
I need to regularly reformat numbers in cells into a custom number (000000000). I create a formatted cell and place a number 1 in it (000000001). I thne...
May 10th, 2010 11:56 AM
by Jan S Go to last post
0 93
VBA data validation by KK[_2_]
Hi all, I have created a textbox input on a userform. I would like to input the postal code here and would like to dala validate it for a 6 numeric input. Is...
May 10th, 2010 12:41 AM
by Rick Rothstein[_2_] Go to last post
6 199
Global Warming and what you can do to against it by ..[_2_]
Dear All, As you know global warming is endangering the future of life on the planet. It will also affect us; rising sea levels, dwindling water supplies, mass...
May 9th, 2010 09:38 PM
by ..[_2_] Go to last post
0 96
Auto insert sheetname into chart title? by Ian R[_4_]
Hi I'm using Excel 2003 I have several charts on a worksheet. At the end of each month I copy the sheet to become the first worksheet in the workbook,...
May 9th, 2010 03:53 PM
by Bob Ryan Go to last post
5 200
Vlookup - Returning 2nd match by MarkinArk
Quick question on returning the 2nd match of a vlookup . I am tracking multiple major league baseball teams' win/loss streaks, and have the results listed...
May 9th, 2010 10:20 AM
by Bernd P Go to last post
4 210
Colour code specific name if it appears in a group of names by Wendy
I want to be able to colour code the name of jo bloggs when his name apprears in a cell that has many names. I have been able to colour code a range of cells...
May 9th, 2010 05:15 AM
by Ashish Mathur[_2_] Go to last post
5 283
Method of viewing/naming columns or conversions for same by Copacetic
Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire...
May 8th, 2010 11:07 PM
by Copacetic Go to last post
3 104
COUNT unique letter in a column by Brian[_16_]
Howdy All, I want to count the number of occurrences of a partipular letter in a column Any help? THanks, Brian
May 8th, 2010 10:46 PM
by Brian[_16_] Go to last post
6 213
Time calculations over 24hrs by Ian R[_4_]
Hi I'm using Excel 2003. I'm trying to calculate the total hours (C1) by subtracting end time (B1) from start time (A1) I have formatted the cells for...
May 8th, 2010 10:10 PM
by Ian R[_4_] Go to last post
5 129
In Excel how do you rearrange a list of address's in alphaetical o by josstex
I have 165 address's on a spreadsheet which using the post codes i wish to put into alphabeticval order, how do i acheive this function?
May 8th, 2010 09:54 PM
by Bob Ryan Go to last post
3 179
Lookup when value is between 2 columns by Yegod
Hi, I need to lookup a column if the value is between the first 2 columns Col 1 Col2 Col3 Col 4 1 5 Yes 10 6 10 Yes 20 11 15 No ...
May 8th, 2010 04:13 PM
by Yegod Go to last post
4 163
Having problem with referencing by Doug
These are the actual values in a portion of a table; If cell "T1" says ".12" I need it to first recognize the closest value, being between 0.1179 & 0.1217....
May 8th, 2010 02:20 PM
by Steve Dunn Go to last post
6 111
Another Sumif problem by Jessejames
A B C D E 1 col tot subtot1 subtot2 DISC 2 black 12 ...
May 8th, 2010 10:50 AM
by Ms-Exl-Learner Go to last post
1 134
Is there a way to format a cell to show aging? by Carolina Girl[_2_]
I am working on a financial spreadsheet and would like to have a column showing how many days have passed after the date in another column. Is there any way...
May 8th, 2010 09:19 AM
by David Biddulph Go to last post
5 119
update vlookup formula sheet reference for multiple sheets by SRH@Boise
In Excel 2003 Starting with this formula I need to have the sheet name change to each tab available on the sheet. =VLOOKUP($A$1,'4-4 to...
May 8th, 2010 08:51 AM
by Jacob Skaria Go to last post
5 171
Index, match, multiple IFs query by zx6roo
I have the following individual...
May 8th, 2010 08:46 AM
by Ashish Mathur[_2_] Go to last post
9 251
sumifs multiple columns help by duketter
Excel 2007- I cannot get my sumifs formula to work. If I just have the sumrange one column of data it works perfect, but I need it to sum multiple columns. ...
May 8th, 2010 08:44 AM
by Jacob Skaria Go to last post
2 141
Post New Thread


Display Options
Showing threads 661 to 680 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:46 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.