|
|
 Up |
|
  |
Author: stunnstunn
Date: Jun 8, 2010 11:23
On Jun 7, 9:44 am, maniarasan gmail.com> wrote:> On Jun 7, 1:24 pm, st...@ sky.com wrote:
>
>
>
>
> >> Okay, so put the formula in a spare sheet, and use the results range
>> as your list values in the dropdowns.
>
>> On Jun 7, 7:07 am, maniarasan gmail.com> wrote:>
>>> On Jun 4, 8:39 am, "Steve Dunn" sky.com> wrote:>
>>>> If "State:" is in A1 and your data is in A12:F17, put this in B2:
>
>>>> =INDEX($A$12:$F$17,COLUMN()-COLUMN($B$1)+2,
>>>> MATCH($B$1&ROW()-ROW($B$1),$A$12:$F$12,0))
>
>>>> Copy across and and down as far as F4 ...
|
| Show full article (2.59Kb) |
|
| |
no comments
|
|
|
Author: Per HorsePer Horse
Date: Jun 8, 2010 10:30
Hi
can anyone tell me if it is possible to protect the row
against the same number.
in my company we have a lot of trucks. they are given a call sign.
like 4428 and 7993
i would like to protect the excel dokument so that i cannot write
examble:
4428
4428
if i write the same id in the same downwords row ther will be an error
|
| |
|
| |
2 Comments |
|
|
Author: MaxMax
Date: Jun 8, 2010 07:59
>> In A2: =IF(Sheet1!B2="x",ROW(),"")
That's the criteria col, returns arb row nums for source rows
satisfying the criteria
>> In B2:
>> =IF(ROWS($1:1)>COUNT(A:A),"",INDEX(Sheet1!A:A,SMALL(A:A,ROWS($1:1))))
Above is the extract and float-up results.
SMALL(A:A,ROWS($1:1)) returns the smallest arb row num from the
criteria col, and as it is copied down it'll return the 2nd smallest,
and so on by virtue of the incrementer ROWS($1:1) which returns the
series: 1,2,3,...
INDEX(Sheet1!A:A, .. then returns the corresponding results from
Sheet1's col A
COUNT(A:A) returns the number of arb row nums in col A, ie the number
of result lines. And once these are exhausted, the trap:
IF(ROWS($1:1)>COUNT(A:A),"",..
ensures that only blanks: "" will be returned, giving the neat clean
look
On Jun 6, 12:58 pm, FSt1 discussions.microsoft.com> wrote:> impressive. could you break down the logic behind this formula.
|
| |
|
no comments
|
|
|
Author: KevrylKevryl
Date: Jun 1, 2010 12:56
Excel 2007
I have pasted a list of all range names (368 of them in all) and I find a
few that have been obsoleted through their location being cut out (eg
"=#REF!$H$1
"). These show ikn the pasted list but not in the range names editing
dialogue box.
Is there a way to delete them? "Edit" and "Delete" in Formulas / Name
Manager are greyed out.
|
| |
|
no comments
|
|
|
Author: KevrylKevryl
Date: Jun 1, 2010 12:32
OK, so I started the experiment and soon got pulled up. I'm saving my .xls
file as a binary .xlsb, and the darned thing wants to put an underscore in
front of range names. I dunno if it applies to all, but the first one not
acceptable was Bal001. Aah yes, would this be because Bal001 is now an actual
cell within the new Excel 2007 spreadsheet size?
I've got a feeling that's probably the case. If so are there any other new
restrictions on range names since Excel 2000?
|
| |
|
no comments
|
|
|
Author: TeenyTeeny
Date: Jun 1, 2010 12:27
I am attempting to create a pie chart with 2 lists of data, in column A I
have a list of occupations and in B I have a recent test scoring. I want a
chart that shows me a comparison of occupation and scores, I have been using
the chart wizard however I am getting a seperate result showing in the chart
for each cell and I need this to show as the scores of each occupation.
I hope this makes sense!
|
| |
|
no comments
|
|
|
Author: KevrylKevryl
Date: Jun 1, 2010 12:24
Agreed. getting more functional but less reliable! Ever since I upgraded from
Word 2.0 to 97 I've wished MS would concentrate on fixing problems before
adding more bells and whistles with their own set of problems and speed
reduction!
And yes, thanks to all who have given of their time to help!
Does anyone know if this vast resource will be transferred to the new
forums, or will it disappear into the ether?
"msnyc07" wrote:
|
| Show full article (1.19Kb) |
|
no comments
|
|
|
Author: winnie123winnie123
Date: Jun 1, 2010 12:21
I would just like to add my thanks for all the help you guys have given me
over the last couple of years. You have been BRILLIANT
I will be sorry to see it close, I would like to hope that there will be
access to archives as searching this site also provided me with alot of
answers to.
Take care everyone
Winnie
"JLGWhiz" wrote:
> Ron, thanks for the link, although like some of the others, I am not so sure
> I will be as active on that site as this one. This whole thing is probably
> part of the tiff between MS and Google....
|
| Show full article (1.70Kb) |
|
no comments
|
|
|
Author: Roger GovierRoger Govier
Date: Jun 1, 2010 11:59
Yes, that is very true Ron - it is a sad day.
I am attempting to set up the bridge (following your useful article),
but still experiencing some difficulties.
The web based format, I detest, and if I cannot set up the bridge
successfully, then I guess I will be an even less frequent poster in
these NG's. My contributions have been severely restricted this past 12
months, as i have been caring for an elderly relative. She is now safely
installed in a nursing home, where she can receive the 24 hour care she
needs.
I was just looking forward to contributing more - and MS have pulled the
plug.
A very big thank you to all the people who have been so generous in the
help that they have given me over the past 13 years.
--
Regards
Roger Govier
|
| Show full article (1.31Kb) |
|
no comments
|
|
|
|
|
|
Author: davwes1davwes1
Date: Jun 1, 2010 11:31
template help stays open on the right side of the screen. If I close it...it
opens again when I open another page.
|
| |
|
no comments
|
|
|
|
|
