Posts by Dick Brich

Re: Scatter Chart Points In Color

Thank you AAE!

Re: Scatter Chart Points In Color

Thank you AAE
I looked at the possible answers and they did not help with what
we need to do.

Good Morning Excel Gurus
would like the points in my scatter chart to be displayed
with the same font color that is in the Data cells being charted.
the cells for the scatter chart contain 2 font colors - red and blue
thank you very much for any assistance
Dick Brich

e.g.
Cell Cell
a2 is red b2 is red
a3 is blue b3 is blue

Re: Loop Thru Column G If True Then Mark That Row & The Next 7 In Column H As True

Thanks for your help - maybe not clear in my question
if this pattern in G
g1000 true
g1001 true
g1002 false
g1003 false
g1004 false
g1005 false
g1006 false
g1007 false
g1008 false
g1009 fales
g1010 false
Then:
h 1000 thru 1008 True
h 1009 h1010 blank

Good Morning OzGrid!

need to loop down Column G - if true then mark that row & the next 7 in column H as true
e.g. g1001 is true so need to mark H1001 thru H 1008 as true
g1002 is true so need to mark H1002 thru H 1009 as true
and so on
g h
1000 false
1001 True True
1002 True True
1003 false True
1004 True
1005
1006
1007
1008
1009
1010
1011

Thanks For any Assistance
Have a GRRREEEAAATTT ought '7
Dick Brich

Re: copy windows directory entries

THANKS JIUK really helps me out

Sorry about the long delay in getting back to you

Great Forum!

Re: copy windows directory entries

Thank You JIUK
Have not gotten anywhere ~

can display directory from Explorer & print screen into Word but
that is essentially useless

Thought it might be possible to get the filename, size & creation date in 3 separate columns in Excel - Maybe not possible?

Thanks Again
Dick Brich

Re: replacing text in excl record with text from outside file?

SORRY danoplex forgot to include column 'C'
'=LEFT(A1,SEARCH("$",A1)-1)&B1&MID(A1,SEARCH(",",A1),LEN(A1))
returns
This is what the description will look like howdy, it's a description of

Re: replacing text in excl record with text from outside file?

something like?
This is what the description will look like $item, it's a description of howdy in a1 of sheet2 (your csv file or whatever)
in column 'B' sheet1
'=IF(ISERROR(ERROR.TYPE(FIND("$item",$A1))),Sheet2!A1,IF(ERROR.TYPE(FIND("$item",$A1))=3,0,""))

Good Afternnon Best forum on the Web

Would like to be able to copy the file names, size, and creation date
from windows directory to an Excel spreadsheet.

e.g. Have a selected directory (from explorer) on screen
Select and copy the file names, size, and creation date
to my excel spreadsheet (to use with monthly, quarterly, yearly
reports to my boss

Thank you

Dick Brich

Re: CountIF Occurances and list

use both the pivot & or Array functions in conjunction is 1 way

see attachment

Re: CountIF Occurances and list

or if not a pivot table;

on Sheet 1:

Col A Col B
Hummana {=SUM(1*(TRIM('sheet2'!$d$2:$d$50000)=TRIM($A<row>))}
Tricare West
Hospital Bla Bla

cntrl+shift+enter to get the {

Good Morning All

Would like to ...Paste Special... Values, Comments, Formats, & Column widths

on a multi-sheet work book without haveing to do each sheet 1 at a time.

Could not spot in FAQ's or other sources so came to the BEST!

Thank you all

Dick Brich

THANK YOU Professor!
Realy appreciate your help!

Is there a way to mark my post as Solved?

What an excellent site!

Good Morning Excel Gurus
I have a spreadsheet that contains 1 or more rows(up to 5) of data per ID number
that I wish to display in Columns on another sheet
Current Sheet - the most an ID can have in the current sheet is 5
e.g.
ID Term Class
1 2004FA Biol
1 2004FA Math
2 2004FA Engl
3 2004 FA EE
3 2004FA Chem
3 2004 FA Mechanics
New sheet I would like to produce
ID Term Class 1 Class2 Class3 Class 4 Class5
1 2004FA Biol Math
2 2004FA Engl
3 2004FA EE Chem Mechanics
Is this possible with Excel?

Thanks
Dick Brich

Thanks for the Charting Help - Should have searched first!
Great Site!

Good Afternoon

Any recommendations for what to use for charting Excel spreadsheets?

We are unable to create attractive, printable charts with Excel's software
as soon as we get beyond 25-30 groups i.e. 66 counties, 50 states etc

Thanks
Dick Brich

Sorry

Thanks Much to Andy & Firefytr for their expert help!

apologize for late response but did not receive an e-mail indicating
a post had been made to my question

will check in the future for responses

Thanks again
Dick Brich

Would like the Worksheet name in a cell in the current worksheet
in a multiple worksheet spreadsheet
Thanks
Dick Brich

Sounds similar - - except on any given filter scenario on any given sheet - you may or may not see the record count -
strange eh? Thanks
For all of your kind
assistance maybe someday will find the answer...