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
locked cells with 2 different passwords? by Zakattack
Trying to setup a timesheet where the user can paste a jpg of their signature and then password protect it. THen forward it to the supervisor who would do the...
June 15th, 2006 06:22 PM
by Zakattack Go to last post
2 68
Consolidating 2 sets of data by Zak
How do you match 2 seaperate sets of data, using 2 colums to match against each other, but then having their corresponding data move with them? I basically...
July 9th, 2004 01:53 AM
by Domenic Go to last post
1 241
Vlookup - maybe?! by Zak
Hi, I want to make use of a vlookup (i think thats what i need!) but not sure how to get it working: I have a drop down list - when user selects something...
September 16th, 2008 11:35 AM
by Zak Go to last post
7 95
IF formula by Zak
I have the following SUMIF statement but i would like to modify the formula so it only counts the the negative numbers, i tried if0 but no...
(Multi-page thread 1 2)
February 1st, 2008 06:57 PM
by Max Go to last post
11 115
Assigning macro to toolbar - only works sometimes! by Zak
I have recorded a few macros for my colleague, i have sent the file across in which the macro was coded and have advised my colleague to assign the macro to...
January 30th, 2008 05:47 PM
by Zak Go to last post
4 70
Can i run 2 IF statements in one formula? by zak
I have a column which can contain only numbers and can only be up to 4 digits long. Is there an IF statement I can write to check for these 2...
February 3rd, 2009 06:16 PM
by David Biddulph Go to last post
3 63
looking for a lookup function by Zak
I am trying to find a function that looks for a value in a list and then return the value 2 cells below in the same colum of a list. What function can I use...
October 27th, 2006 12:09 AM
by Zak Go to last post
2 62
Index and match functions help needed. by Zak
I have the following column headings: "Names" "Date" "Title Plan Reference Number" "Work Recording System" "Audit Stage" Now if I enter the name AND date i...
September 1st, 2005 02:08 PM
by Max Go to last post
5 143
Simple Question by zahoulik
I'm trying to add some sort of cross-check to my spreadsheet. I need to make a function that compares the sum of a list of numbers and another number (taken...
December 20th, 2005 02:07 AM
by Ashish Mathur Go to last post
3 76
vlookup by zahoulik
Hello, I'm getting really frustrated with vlookup. I'm looking at a document that uses it a lot and I'm trying to figure out where it's getting these...
December 21st, 2005 08:10 PM
by CLR Go to last post
1 93
Conditional Formatting when inserting a row by zahoulik
My conditional formatting is =SUM($E$2:$E$9)$E$1. When this returns true, all of the cells E2:E9 turn red. But in the future, I will need to insert a row...
January 7th, 2006 04:01 PM
by Barb Reinhardt Go to last post
2 273
how to express number "9" to "Nine" by Zahir Alam
I want to express a number in to text format 2235 to "Two thousand two hundred thirtyfive"
August 21st, 2008 10:56 PM
by ryguy7272 Go to last post
2 112
how do i truncate text-- create cell with only 125 charecters by zahara
i have a spreadsheet to import into a database. some cells have over 125 charecters for a field where the database only has 125. i'd like to create a new...
July 5th, 2006 08:23 PM
by kassie Go to last post
2 75
countif and sum if if two condition are satisfied by zafar62
I have the data as under A B S 2 S 3 F 4 F 0 M 5 M 6 I want to count...
July 15th, 2008 06:22 AM
by ryguy7272 Go to last post
3 78
i need formula which convert figure in to text by Zafar
i need formula which convert figure in to text
August 22nd, 2007 12:44 PM
by Toppers Go to last post
1 65
i need formula which convert figure in to text by Zafar
i need formula which convert figure in to text
August 22nd, 2007 01:34 PM
by JLatham Go to last post
1 68
Difference of two dates by Zafar
Hi all, I would like to ask if anyone can suggest me a funtion or a formula in Excel on how to calculate the difference between two dates in the format of...
July 26th, 2007 08:44 AM
by David Biddulph Go to last post
3 39
TIMESHEET by Zaf
I am currently attempting to work out the flexi time earned and taken in a week. The problem i am having is that if some one is taking flexi they would have...
June 20th, 2008 10:43 AM
by Zaf Go to last post
2 46
How do i add a column of values based on another column in excel by Zaebos
I am doing up a minor budget scheme and I am a little stuck on this one. I have 2 columns. First column is an amount and the second column has different...
September 19th, 2006 08:29 PM
by Toppers Go to last post
2 63
Count non-consecutive cells..... by Zadig Galbaras
Hi! I have this spreadsheet looking kind alike this: A1=X B1="" D1=X F1="" H1=X
September 26th, 2004 10:48 AM
by Aladin Akyurek Go to last post
7 323
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 02:29 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.