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
Excel drag down formula not working good.. by zoola ander
hi, i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0))) when i drag...
May 8th, 2008 10:38 PM
by zoola ander Go to last post
0 72
Excel drag down formula not working good.. by zoola ander
hi, i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0))) when i drag...
May 9th, 2008 08:51 AM
by David Biddulph Go to last post
1 68
vba excel macro question...ranges by zoola
Hello, I have been asked by a friend to help with vb/excel, however i have not touched vb in my life. I have a background in c/c++, so if someone could point...
July 6th, 2005 08:56 PM
by Don Guillett Go to last post
3 144
Excel drag down formula not working good.. by zoola
hi, i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0))) when i drag...
May 8th, 2008 11:04 PM
by akphidelt Go to last post
1 74
how do I keep column titles on subsequent pages of a pivot table by Zoo7
When you have a pivot table that is two or more pages long, how do you go about ensuring that the column titles are on each page? looking forward to your...
December 10th, 2005 12:59 PM
by Roger Govier Go to last post
1 92
Special today Date challenge question by ZONNET
What I want is have a today function eg in cell A1. based upon entering any text in for eg b2, puts me the julian dat in cell A2, So far, so good, I got that...
November 19th, 2003 07:18 PM
by Don Guillett Go to last post
1 390
Which function do I use? by Zong
Workbook with 2 spreadsheets. I need to look up a part number in one column and have it give me the value in another column on the same row. PS# ...
February 23rd, 2009 12:20 AM
by T. Valko Go to last post
7 77
Excel comments by zonegrise
Hi, Is possible to change the default font type in Excel comments? (not just the size but the font itself)
June 16th, 2009 10:51 PM
by Gord Dibben Go to last post
1 223
Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' by Zona
I am trying to add a worksheet but the "WORKSHEET" function is not available in INSERT
September 6th, 2006 03:52 AM
by Dan Hatola Go to last post
1 63
HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC by zomex
if the names given are peter alan smith geroge w bush william scott scotty than how can i retrive the last name, in another cell... like for the retreval of...
November 29th, 2005 04:36 PM
by zomex Go to last post
5 83
how to get the middle name by zomex
how can i get the middle name like "george w bush" how can i get W
December 5th, 2005 11:32 AM
by Bill Kuunders Go to last post
1 71
how to get the middle name by zomex
how can i get the middle name of "fazain iqbal khan"... i can get the last name by =(a2,len(a2)-search("#", substitute(a2&" "," ","#",2)))... and...
December 6th, 2005 02:26 PM
by Roger Govier Go to last post
2 64
help needed by zomex
eg. "mick jagger bush" "muhammad ali clay" "ayesha bin batool" suppose that these r the names and i want formula that would be generic to all, such that it...
January 4th, 2006 01:54 PM
by Ron Rosenfeld Go to last post
5 69
help by zomex
guys how can i generate a formula that would lead to even number letters like"bush" "clay" "boss" "sale" "cout" to have capital letter of first and third...
January 4th, 2006 06:53 AM
by JulieD Go to last post
1 72
help by zomex
if names r given to me which contain even letters like "bush" "boss" clay" "wali" "walou".... how can i generate a formula that would lead to the first and...
January 4th, 2006 02:41 PM
by Ron Coderre Go to last post
1 56
HOw do I display text in the data field of the pivot table, inste. by Zoltan
I am trying to get the pivot table to display in the data field the cell VALUE (and not sum, count, dev, etc. of the cell) in a pivot table. Please...
March 2nd, 2005 07:21 PM
by Gary Brown Go to last post
1 116
vlookup by zolabus
Hi i have two column with similar but not equal values haw can i use vlookup to see wich elements of the B column are not in the A column? Thanks a lot
August 22nd, 2007 02:46 PM
by Max Go to last post
1 51
filter by zolabus
Hi and sorry for my english when i use the authomatic filter i need that the results are numbered in a near column. Is it possible?
August 20th, 2007 04:59 PM
by Bernie Deitrick Go to last post
1 47
SHOW AUDIT ARROWS by ZOEY GREENE
how can I show viewers the audit trail arrows in a saved filed? say, when I email an excel file, I want the recipients see the audit trail arrows when they...
September 5th, 2008 08:43 PM
by ZOEY GREENE Go to last post
0 79
How do I format a cell based on the contents of a different cell? by ZoeMcGoe
I have a column of values that can have one of four possible values in each cell - let's say Red, Amber, Yellow or Green. If the cell has the text "red"...
February 10th, 2009 08:03 AM
by Pecoflyer[_157_] Go to last post
7 75
Post New Thread


Display Options
Showing threads 161 to 180 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 07:42 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.