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
is there any built in function to draw lines by krishnan
Having given two dates is there any way to plot line from these two dates. ( say dates in continuous cells) Regards, Krish
June 22nd, 2009 01:31 PM
by Joel Go to last post
2 77
Delet Duplicate Blanks rows by hardeep.kanwar[_16_]
Hi! to Everyone There are many Software and Addin and Macro or Code to Delete or Eliminate the Duplicate Data But, I want to Delete The Duplicate BLANKS...
June 22nd, 2009 01:17 PM
by Ashish Mathur[_2_] Go to last post
6 89
Header Row with Option to Shrink/Expand Rows Beneath by kippers
Hi, I'm sure I've seen someone do this but I can't remember how it was done... Basically I am trying to group a number of rows under a heading row (in a...
June 22nd, 2009 12:50 PM
by Jacob Skaria Go to last post
2 65
Lookup to return multiple matching values by olssonj
Hi! I have one workbook with two sheets. Sheet one is used to define where our consultants are booked every day through the fiscal year. The sheet includes...
June 22nd, 2009 10:13 AM
by olssonj Go to last post
5 100
Compare multiple columns-----siva and surya by siva
Subject site column A column B column C Columnd E001 1 Hyperthyroidsm Astma check E001 ...
June 22nd, 2009 07:05 AM
by siva Go to last post
0 80
How do I get the sum of vlookup? by jiffy
I have 4 worksheet each with over 80 rows of information. I want to lookup a code in one column, and if found I want the value from the immediately adjacent...
June 22nd, 2009 06:28 AM
by Jacob Skaria Go to last post
3 76
Error result for link formula by tj
Hi, I got data as follows: Date Material ($) Labour ($) 1/1/09 100 - 22/1/09 - 150 2/2/09 200 ...
June 22nd, 2009 06:12 AM
by tj Go to last post
4 94
Using Cell Contents to Select Worksheet with Same Name as Cell Con by Alan Sexter
I am a quantitative analyst who is the leader of our department's Excel users group (Multi-Channel Marketing department of Eastbay, Inc. in Wausau,...
(Multi-page thread 1 2)
June 22nd, 2009 04:59 AM
by Simon Lloyd[_301_] Go to last post
14 169
HLookUp function by Jbig
Wondering if anyone can tell me where exactly do I add the asterisk symbol to multiply within this function. So far I have: =HLOOKUP(C4,'Risk...
June 22nd, 2009 04:07 AM
by Jacob Skaria Go to last post
2 74
Filter by Color by Chin via OfficeKB.com
Khalil, I Exccel 2007, you can sort by colour. Just go to "Data" -- "Filter" -- "Sort by Colour". Khalil wrote: Dear Experts; I have a data...
June 22nd, 2009 01:46 AM
by Chin via OfficeKB.com Go to last post
0 65
Wrong results from MATCH function by Imladrian
Softwa Excel 2007 SP1 I'm using the FV function to compare future returns on investments. The results of the six scenarios in row 36 are as...
June 22nd, 2009 01:41 AM
by Bernard Liengme[_2_] Go to last post
3 67
Summarising information from different sheets in a summary sheet by Naida T
Dear Excel experts, I am stuck with a problem here which I am trying to solve manually, but knowing Excel, there MUST be a more efficient (time-saving and...
June 22nd, 2009 01:18 AM
by Max Go to last post
2 74
Pivot table - Change default summarise value field. by YY san.[_2_]
Hi, By default, the summarise value field in the pivot tabel is always COUNT. Does anyone know that this default, can it be change to SUM? Thank you in advance
June 21st, 2009 07:21 PM
by Dave Peterson Go to last post
2 86
Can any help with CUBESET function? by Janie
I am learning CUBE functions. The only one I can't get to perform is CUBESET. Here's my scenario: I've constructed an offline OLAP Cube using Access...
June 21st, 2009 07:07 PM
by Janie Go to last post
0 350
Formula problems that keep producing a #Value! Error!! by Danny Boy
I am trying to get this formula to average the values in row I for all individuals seen during the year 2008. The formula also acknowledges that it should...
(Multi-page thread 1 2)
June 21st, 2009 06:11 PM
by T. Valko Go to last post
10 135
over time in a sheet by chilson
i need to put overtime in a work sheet but here is what i need to do if you work Between 12:00 am to 8:00 am this is double time now how do i calculate...
June 21st, 2009 05:52 PM
by Rick Rothstein[_2_] Go to last post
2 79
how can i "transfer data next row every day automatically" in XL by Nisar
I create a spread sheet in 12 row and 10 columns . i want run loop in rows set by the date. every day it should show next row data automatically
June 21st, 2009 01:11 PM
by Don Guillett Go to last post
1 74
custom field with custom formula in pivot table! by Sedaghat Nejad
Hi to all; I have a pivot table that contain "task-start-date" field I want to add a costom field to my pivot table with this formula :...
June 21st, 2009 11:19 AM
by Sedaghat Nejad[_2_] Go to last post
2 92
Conditional Formatting - Times by kristy_6278
tHow can I work out using conditional formating that this employee is double booked with the time scheduled falling in between a current workshop he is...
June 21st, 2009 10:50 AM
by Bernard Liengme[_2_] Go to last post
1 73
? excel not generate the sensitivy, answer and limits report by Bernard Liengme[_2_]
You have to specify these in Solver's Options They are on separate worksheets added by Solver In future, please write question here in the white space , not...
June 21st, 2009 10:43 AM
by Bernard Liengme[_2_] Go to last post
0 76
Post New Thread

Display Options
Showing threads 9921 to 9940 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 01:28 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.