I need to compare 3 numbers and find the one in the middle
I have three numbers in a single row and would like to identify the middle
number enter that number in another cell.
1st # 2nd # 3rd # result
628 678 720 678
655 625 700 655
748 720 725 725
is there a function in excel that can do this?
VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56811
fasteddie wrote.....Find Duplicate names and delate
I have a small doubt could you clarify that???
That is I find duplicate name but I want to delete one name only, if I
filter DUPLICATE….. both names are showing…
1. Select the range of data including the header. You need to have headers
for these columns
2. From menu Data>Filter>Advanced Filter>Copy to another location
3. In 'copy to' specify the target cell and check 'Unique records only'
4. Click OK will give you the unique list
"Find Duplicate names and delate" wrote:
> Dear experts,
> I have a small ...Report not applying selected parameter
I have created an rdl file in vs2005 that has a string parameter that is
pulling from a dataset. when I preview the report I select the parameter
from the dropdown list and click View Report yet the report does not filter
based on the selected parameter. What am I missing?
Can you post your query?
MVP SQL Server Reporting Services
"ahmed" <firstname.lastname@example.org> wrote in message
> I have created an rdl file in vs2005 that has a string parameter that is
> pu...Excel files reporting read only
I have an issue where a user I provide support for is being told that a
file that has not been opened for a couple of months is reporting as
being locked for editing by the last user to save the file (in some
cases these users no longer exist on our network). When you check the
open files on the server, these files are not showing as open.
If teh user clicks to close, and then immediatley re-opens the file it
opens as normal.
There are no temporary files in the folder that the files are located
in and I have cleared the temp folders on the client and on the server.
The user has full control...How to show a field for Many-One-Many relationship (Report Writer)
In the Tax Transaction report, I wish to show the "Vendor Document
Number", but the result showing duplication of records, suspect the
report result cause by the Many-One-Many relationship of those tables.
In the Tax Detail Transaction Report contains a list of Receipt
Numbers (POP) that involving tax, and this report showing the Vendor
ID and Vendor name, but it do not have "Vendor Document Number".
So, I added a new relationship in order to show the "Vendor Document
Number" which can be found in the PM Transaction Open File. Due to the
...Finding a Median
I'm trying to write a query that will return a median for various
values taken from a previous query. I've seen some suggestions in my
searching, but I haven't been able to get them working. They are also
all from before 2003 and refer to Access 97 and 2000.
Has any functionality been added to 2003 for this? Or is there a non-
code-based way to do it? I've seen it suggested to write a code to
open the query, sort it, find the total number of records, divide it
in half, then seek out the middle record using that value. I'm still
very green when it comes to code, though...Find a Value the first Time It Occurs
I have a row of values that shows the total cumulative number of sales of
items by month. Occasionally, there may be no sales in a month for an item
so the cumulative value would stay the same for more than one month. I want
to select a number in the row the first time it occurs and not select it if
What are you wanting to do with the info?
To return position (column number) of number 1234 within row 2:
A formula that signals it's the first occurence:
This could be used in a helper row, or as a conditional format f...Find/Replace in RichEdit 2.0
I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
CRichEditDoc/View application so that I can use the ITextDocument
interface and can do things such as suspend/resume the Redo buffer.
Problem is, now the Find/Replace dialogs don't seem to do anything. If
I revert back to RichEdit 1.0 they do!
What's going on?
email@example.com (Adrian Gibbons) wrote in message news:<firstname.lastname@example.org>...
> I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
> CRichEditDoc/View application...Sales Reports
We just upgraded from v1.2 to v3. I'm trying to run reports on our sales
pipeline. However, v3 doesn't have anywhere near the amount of pre-canned
reports that v1.2 did? We have become heavily dependent on some of those
reports for analyzing our sales cycle and now I don't know what to do. Are
we all expected to be programmers and modify these reports to our liking?
What happened to all of the reports the previous version had? Am I missing
I think it has to do with the fact that CRM is now using SQL Reporting
Services instead of Crystal, which repor...sales forecase report
Is there a report in GP 10.0 Manufacturing that will show what raw material
parts will not satisfy the finished goods housed within a sales forecast that
is in place?
This can be accomplished through the use of MRP which takes Sales Forcast as
and input and allows orders to consume that forcast. MRP will then suggest
Purchase Orders and Manufacturing Orders to meet the required demand.
> Is there a report in GP 10.0 Manufacturing that will show what raw ...How to fix the filter of a report
I have a modified or "CUSTOM" report that when I select just one item, it
displays all items.
Where in the report can I troubleshoot this problem and fix that when I
enter just one itme, it print just one item.
...Find (but not find)
My program takes a name from sheet3 goes to sheet1 to Find the name.
If it cannot find name, how do you do an If/End to Exit Do while or
find out if name has been founf? I have "On Error Resume Next" in
Thanks again for all your help
As ALWAYS, post your code for comments & suggestions.
Microsoft MVP Excel
"Gordon" <email@example.com> wrote in message
> My program takes a name from sheet3 goes to sheet1 to Find the na...Non printing of check boxes in a Report
I have come back to using Access and although I have managed it before I
cannot get Check Boxes to print in a Report. They are visible on screen but
when I want to print the Reports the space where the check boxes should be
whether 'a tick' or 'blank' is empty.
Try changing the font. It may be something your printer doesn't have the
font for, while substituting another similar font for other characters.
"Jenny" <Jenny@discussions.microsoft.com> wrote in message
>I have come back to using ...Finding an event
I am developing an app that uses a single worksheet to enter data. When user double clicks a button, a new window (in same workbook)
opens with a new sheet. My problem is that excel does not seem to have any events for close of window if there are multiple windows
in a workbook.
Can someone help
That triggers the Workbook_WindowActivate event, you can use that.
"Peter Ostermann" wrote in message
I am developing an app that uses a single worksheet to enter data. When user
double clicks a button...Find value in a column and insert rows above
The set up looks like this:
ColU ColV ColW ColX
Y N N N
Y N N N
N Y N N
N N Y N
N N Y N
N N Y N
N N Y N
N N Y Y
Columns will always be U through X and will always be sorted in this order.
I need to find the first Y in each column and insert 2 rows above that row.
On the blank row above the first Y, I need to highlight in yellow and put
title in the first cell, such as New, Old, Existing, Deleted.
Any help would be greatly appreciated.
Thanks for your time,
If desired, send your file to my address below. I will only look if:
1. You send a copy of this ...Upgrading reports from CRM 3.0 to 4.0
Having spent around 10 hours trying to upgrade a custom report from CRM 3.0
to CRM 4.0, I thought I’d post a message to share my pain and the solution!
It appears that in CRM 4.0 Microsoft have made a change to the way in which
the standard reports retrieve the name of the user running the report. I have
been unable to find any documentation about this.
If you have a custom report that is based on a standard CRM 3.0 report (i.e.
it has the CRM_FullName parameter & UserInfo dataset) and upload it into CRM
4.0 then try to run it, you may get either of the following behaviours
• Th...cannot find database
I have an excel spreadsheet that is supposed to update a access db.
Whenever I try to save the .xls I get an error stating cannot find db.
Even when I open the db with access, I get the error and the db opens
anyway?????? This only happens on 2 out of 20 pc's and I cannot figure
...Remove Header Once Report Displays?
I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.
It isn't clear what you mean by "The header contains the main report which is
quite confusing since fields are not the same". A subreport contains nothing
from the main report. When you mention "...Sum if Condition is Equal in Range Date and find column
I want to make a sum if Range is a week number and if style is Equal to
CONC-92 or CONC-45
Week# 49 Week# 50
CONC-92= 27 CONC-92= 30
CONC-45= 27 CONC-45= 30
Datas are in a pivot table and...
Pivot table looks like this:
Date CONC-92 CONC-45 CONC-92 CONC-45
12/7 5 5 10 10
12/8 2 2 10 10
12/9 5 5 10 10
12/10 5 5 10 10
...Trapping a NO FIND after a find
I use the code below to store a row number to a variable after a find.
I would like to trap a NO FIND if the find is unsuccessfull
Any ideas. FSt1 provided the code below
dim rn as string
dim rng as range
dim therow as long
rn = inputbox("enter something to find")
if rn <> "" then
Set rng = nothing
Set rng = range("A1:IV65536").Find(what:=rn, _
...How do I find the out of office reply?
My out of office reply is missing from tools. How can I retrieve it?
Out of Office reply <Out of Office firstname.lastname@example.org> wrote:
> My out of office reply is missing from tools. How can I retrieve it?
Unless you are using an Exchange server, you will not have the Out of Office
Assistant. See this: http://www.slipstick.com/rules/autoreply.htm
...How do I create custom report from stored procedure
I need to create a report form stored procedure. My stored procedure
selects the data and inserts in temp table.I am executing stored procedure
from pre query and selecting coloumns from temp table . But I am getting
Invalid object name temp. Is it possible to execute the report from stored
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access to your favorite newsgroup -
microsoft.public.pos - 40088 ...Finding numbers in rows and highlighting them
Hi everybody :)
I need help.
This is a lotto system.
I have a spreadsheet with 508 rows and 45 columns.
In each row there are 45 numbers mixed (1 to 45).
I need a script or some other way to find where particular (drawn)
numbers are in each of the 508 rows.
If my explanation is not clear please ask for farther clarification.
Thank you in advance for your help.
Johncobb45's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1658
View this thread: http://www.excelforum.com/showt...Subject Node parent-child report problem
I'm trying to filter\run report cases according to subject hierarchy.
In the "advanced find" all I can choose is the specific subject
regardless his parent.
The same behavior occur when I export the whole cases table to excel as
a pivot table.
Any suggestion would be of assistance.
Can you explain further. In a report you will only get the node you
selected. Are you wanting to get nodes further up the tree?
Microsoft CRM MVP
"Niel100" <email@example.com> wrot...How do I find data from a list (or table) and insert it in a row?
I used to use a spreadsheet program (2 years ago) that allowed me to lookup
an item and insert it into the worksheet. I know the program was at least a
year old at that time (2002). How do I create a list, reference it , and
then insert an item into a row of my choice?
Example: Make of item, item description, and cost.
Does the data go on one worksheet and then get referenced and inserted into
the list of another worksheet? If so, how? I can't seem to get any answers
by reading books on the subject. I no longer have access to the old workbook
from which to study.
Maybe that ...