+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 201 to 298 of 298

Call in the Cavalry - 2015

  1. #201
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    Hi Glenn,
    Quote Originally Posted by Glenn Kennedy View Post
    I think I'm beginning to understand what (s)he wants; but right now, I've lost the will to live...
    .. I know that feeling

    Quote Originally Posted by Glenn Kennedy View Post
    Any takers?
    . I will give it a quick try... looks like the sort of sorting thing I often do.. ( But I will insist on a Before and After sheet. )
    Alan
    Last edited by Doc.AElstein; 08-09-2015 at 07:07 AM.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  2. #202
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Call in the Cavalry - 2015

    Thank you, Alan!!!
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #203
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    OP is looking for easier way / shorter formula.

    I'm out of ideas.

    http://www.excelforum.com/excel-form...-weekends.html
    Dave

  4. #204
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-form...ml#post4159955
    Anybody have ideas to a custom format for the OP.

    Maybe a moderator can swing by and clean up the garbage posts as well that is diluting the value of the thread.

  5. #205
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2015

    Hopefully, one of you will realize what is wanted here.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  6. #206
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by xladept View Post
    Hopefully, one of you will realize what is wanted here.
    I can't...... But
    FWIW. I will try.... and get the OP to give a good Before and After, then if I can understand it I will try to answer his request..

  7. #207
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by xladept View Post
    Hopefully, one of you will realize what is wanted here.
    ... I not know if this guy real for is, or plant patience from us test to can be &%%§%=(**1§$

    http://www.excelforum.com/excel-prog...ml#post4161884

  8. #208
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Call in the Cavalry - 2015

    I don't think it's that bad, it's just his English isn't very good, he just wants to loop through the rows and put the date in if there's a 1 in the column.

    Granted it would be much easier with a sample workbook though!

  9. #209
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2015

    Granted it would be much easier with a sample workbook though!
    - Kyle

    He did post a sample but, I still don't get it

    Hey Doc and Kyle, thanks for looking

  10. #210
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Call in the Cavalry - 2015

    Haha no problem, I'm in a good mood and Alan's rep comments are ace, I'd have thought that that was a pretty obscure swear word for English, so as a German speaker I'm impressed that you know it!

  11. #211
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Call in the Cavalry - 2015

    Anyone care to visit, or re-visit, this thread: http://www.excelforum.com/excel-prog...ed-varies.html

    I can't look at it for a while and I'm out of ideas anyway

    Thanks, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  12. #212
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    This one seems to be mostly a financial question, and I have no experience with Excel's financial functions. The OP does not even seem sure of the underlying equation he should be using (though he does make reference to the ACCRINTM() function). I expect that someone who is not only familiar with Excel's financial functions but financial calculations in general (specifically interest on securities) should be able to make short work of this question.

    http://www.excelforum.com/excel-gene...l-formula.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  13. #213
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2015

    Any peeps with experience adapting macros for Mac environment, a little help here would be appreciated.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  14. #214
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Call in the Cavalry - 2015

    Looks like VBA needed here. Not one for me, then!!

    http://www.excelforum.com/excel-gene...-in-excel.html

  15. #215
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2015

    Anybody do this before?
    http://www.excelforum.com/excel-prog...o-outlook.html
    Send e-mail from excel and get message it was sent

  16. #216
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2015

    Another simple macro made difficult because I don't know anything about Macs, if you can assist in tweaking this to save correctly on a Mac system, the OP and I would be ever-so-grateful.
    http://www.excelforum.com/excel-prog...directory.html

  17. #217
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Call in the Cavalry - 2015

    Anyone with Office 2013 care to take a look at this. http://www.excelforum.com/excel-prog...tpassword.html

    Ideally, with 2007 and/or 2010 to make a direct comparison on the same machine.

    Regards, TMS

  18. #218
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Call in the Cavalry - 2015

    I'm not sure what he is trying to do...and I don't think I'm actually helping...

    Sooooooooooo, Guru's, come on down....thanks


    //www.excelforum.com/excel-programming-vba-macros/1100914-incorrect-syntax.html
    Last edited by judgeh59; 08-25-2015 at 04:36 PM.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  19. #219
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Call in the Cavalry - 2015

    Who is good with formatting and Character.

    This one has got me stuck...

    http://www.excelforum.com/excel-prog...ml#post4174165
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  20. #220
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2015

    This OP is completely missing my point and I decided to stay away from this thread. So anyone please take care of this thread.

    http://www.excelforum.com/excel-form...-dropdown.html


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  21. #221
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Call in the Cavalry - 2015

    I've replied in your thread but the forum's having a paddy so it doesn't show as though I have

  22. #222
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Call in the Cavalry - 2015

    Yes its happening for me too. I typed that content twice to get it podted here.

  23. #223
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by Kyle123 View Post
    …. but the forum's having a paddy so it doesn't show as though I have
    …..
    .that usually takes a while to show Today…
    Quote Originally Posted by :) Sixthsense :) View Post
    Yes its happening for me too. I typed that content twice ….
    . I replied too. And I too have been having problems all day with the Forum Software doing things like that or not being accessible for a long time
    http://www.excelforum.com/suggestion...ml#post4180394
    Alan

  24. #224
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Call in the Cavalry - 2015

    Anyone who speaks Dutch can help with conditional formatting? http://www.excelforum.com/excel-prog...-datelist.html
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  25. #225
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Call in the Cavalry - 2015

    Anybody has an idea for this post please?
    http://www.excelforum.com/excel-prog...ml#post4185773

  26. #226
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Having trouble meeting all of the criteria here

    http://www.excelforum.com/excel-form...-countiif.html

    apples and oranges can only be summed from Set 1, Bananas and Cherries only from set 2

    If non unique orders occur, as in rows 2 and 3, only sum it once.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  27. #227
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2015

    Why did I even try to step in here? The fact that nobody else did should have been a good hint...
    Anyhow, I snipped a picture of the button already there and used it as a background for a Modeless Userform, so far so good. Then I started to write code for when this Userform would Show and when it should Hide and realized I shouldn't have. I saw there was some very complex way to capture the scroll event out there on the interweb also

    http://www.excelforum.com/excel-gene...scrolling.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  28. #228
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2015

    Is this a math problem or is it just a silly circular reference?
    http://www.excelforum.com/excel-gene...variables.html

  29. #229
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Call in the Cavalry - 2015

    @Jacc:
    task 1 is total n. of h - h spent for tasks 2 and 3
    task 2 is 20% of task 1 + 15% of task 3
    task 3 is total n. of h - h spent for tasks 1 and 2
    That is most definitely circular and I don't know how you could make that work.


    Regards, TMS

  30. #230
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    I think I'm over complicating again.

    http://www.excelforum.com/excel-form...ml#post4193739

  31. #231
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2015

    Im not even going to try and break that 1 down, CB...
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  32. #232
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by FDibbins View Post
    Im not even going to try and break that 1 down, CB...
    Where did that one come from?

  33. #233
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2015

    This thread has me stumped.

    I've helped him with all the formulas in the preceeding columns but the lastest one seems a bit tricky.

    INDIRECT() plus SUMPRODUCT() plus current year only limitations.

  34. #234
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by TMS View Post
    @Jacc:

    That is most definitely circular and I don't know how you could make that work.


    Regards, TMS
    Interesting development here:
    http://www.excelforum.com/excel-gene...variables.html

  35. #235
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    I am not sure what is going on with this one: http://www.excelforum.com/excel-gene...-up-chart.html
    Excel does not want to chart the entire data set for the two series that have data, it only charts part of the data.

  36. #236
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    This one wants to do calculated fields in Pivot table that they can apply slicers to.

    I've never done that before and don't have a clue.

    http://www.excelforum.com/excel-char...e-average.html

  37. #237
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

  38. #238
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2015

    Can someone help this OP - the code looks foreign to me

    http://www.excelforum.com/excel-prog...ml#post4200370

  39. #239
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2015

    Could anybody see if these instructions to hyperlink to a word doc will work for them
    http://www.excelforum.com/excel-form...ml#post4201180

  40. #240
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    I am out of ideas. OP is trying to summarize LARGE and SMALL values across multiple sheets.

    In spite of merged cells this part is working.

    =LARGE('Season 1:Season 3'!$AF$2:$AH$11,ROWS($1:1))

    This is not.

    =SMALL('Season 1:Season 3'!$AF$2:$AH$11,ROWS($1:1))

    My every attempt to coerce blank cells to FALSE fails. I've tried INDIRECT references to the sheets and only values from the first sheet return.

    I'm missing something obvious I'm sure.
    Anyone have some ideas?

    Edit Left out the link. Sorry.
    http://www.excelforum.com/excel-form...e-columns.html
    Last edited by FlameRetired; 09-29-2015 at 01:10 AM.

  41. #241
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Call in the Cavalry - 2015

    A link would be nice - but my sherlock cap tells me you're referring to http://www.excelforum.com/excel-form...ml#post4202540

    Now, here's the funny thing. Try creating the formula by typing and selecting the cells using the mouse. I find that I cannot select Season 1 Season 2 and Season 3 sheets at the same time, i.e. it doesn't allow me to do 'Season 1:Season 3'. I don't know why that is the case. Here's the better part, when I create a copy of all the sheets unto a new workbook, it now works - and the SMALL function works too. Another Excel oddity perhaps.

  42. #242
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    @ quekbc

    Sorry about that.

    Here it is.

    http://www.excelforum.com/excel-form...e-columns.html

  43. #243
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    Quote Originally Posted by quekbc View Post
    Now, here's the funny thing. Try creating the formula by typing and selecting the cells using the mouse. I find that I cannot select Season 1 Season 2 and Season 3 sheets at the same time, i.e. it doesn't allow me to do 'Season 1:Season 3'. I don't know why that is the case. Here's the better part, when I create a copy of all the sheets unto a new workbook, it now works - and the SMALL function works too. Another Excel oddity perhaps.
    I hadn't tried any of that and yes that is bizarre.

    And thanks. I've passed that on.
    Last edited by FlameRetired; 09-29-2015 at 01:19 AM.

  44. #244
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    @quekbc
    Thanks for looking into that one.
    Good find on the hidden sheets.

  45. #245
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2015

    Again I'm on deep water. I assume there is a way of restructuring the data and use Pivot Table from multiple sources but I couldn't figure it out. Or is formulas the way to go? I reckon you have free hands to do whatever on this one.
    A bit of doubleposting going on as well I guess.

    http://www.excelforum.com/excel-form...ncatenate.html
    http://www.excelforum.com/excel-gene...e-formula.html

  46. #246
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Call in the Cavalry - 2015

    Anybody have time for a time formula?
    http://www.excelforum.com/excel-gene...ml#post4206938

  47. #247
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Out of time here. Don't want to leave her hanging

    http://www.excelforum.com/excel-form...two-files.html

  48. #248
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Call in the Cavalry - 2015

    I hate to call in the big guns on something that should be fairly simple but I cannot figure out what this person wants...
    http://www.excelforum.com/excel-form...mn-choice.html
    And furthermore, now that I'm at work I cannot see his latest image he attached.
    Perhaps someone else can understand what he wants?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  49. #249
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    This is humiliating. I cannot tell for the life of me why such a simple INDEX / MATCH formula should not work. Have checked for rounding errors etc. An array form of the formula works but not the simple one. Also LOOKUP works, but not HLOOKUP.

    http://www.excelforum.com/excel-form...need-help.html

    Edit Thanks to everyone who answered the "alarm". This was an education. I thought I was losing my mind.
    Last edited by FlameRetired; 10-09-2015 at 03:23 AM.

  50. #250
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    OP says he is interested in a pivot table/Powerpivot solution: http://www.excelforum.com/excel-form...ml#post4213491 I don't know pivot tables, but suspect that it will be a very effective approach for what he/sheis doing.

  51. #251
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    My conclusion is that this one may not be possible exactly as the OP envisions it: http://www.excelforum.com/excel-gene...d-in-cell.html If I am wrong, I am hoping someone can step in and help.

  52. #252
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Call in the Cavalry - 2015

    As soon as I see:

    'Please provide me non VBA or Macros solution.'

    I know where it is originating from & I am out.



  53. #253
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the Cavalry - 2015

    Does anyone know the idiosyncrasies of advanced filter?

    This thread is in dire need.

  54. #254
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    Hi
    Quote Originally Posted by xladept View Post
    Does anyone know the idiosyncrasies of advanced filter?

    This thread is in dire need.
    I am a bit out of my depth here, but had a similar prob.. i think i can get the OP code to work...
    Alan
    http://www.excelforum.com/excel-prog...ml#post4217202
    Last edited by Doc.AElstein; 10-15-2015 at 06:55 PM.

  55. #255
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    this one went from a rounding issue to a something to do with the "tooltips" that pop up over chart data points. I have no knowledge of what if anything is changeable in these tooltips. I anyone can contribute anything more to this discussion, it would probably help the OP. http://www.excelforum.com/excel-gene...ml#post4218654

  56. #256
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Call in the Cavalry - 2015

    Am I missing something obvious here?

    http://www.excelforum.com/excel-prog...and-paste.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  57. #257
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Call in the Cavalry - 2015

    Need someone's help on 2nd and 3rd request here
    http://www.excelforum.com/excel-form...ml#post4219798
    Quang PT

  58. #258
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Call in the Cavalry - 2015

    Anyone care to have a look at this. I suspect that I over-simplified the response and it probably does need VBA. But I'm struggling with wood and trees right now.

    http://www.excelforum.com/excel-prog...condition.html


    Thanks, TMS

  59. #259
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Call in the Cavalry - 2015

    Digital Signatures? Anyone have any experience there that can help this OP.

    http://www.excelforum.com/excel-gene...el-2013-a.html

  60. #260
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    Another one that went from something I thought I knew how to do into the broad unknown of pivot tables: http://www.excelforum.com/excel-char...ace-chart.html I have requested that he/she upload a sample file to see what the source data for the pivot table looks like. If anyone who is good with pivot tables can step in and help us understand how to get the pivot table to summarize the data the way he wants, it would be appreciated.
    Last edited by MrShorty; 10-21-2015 at 12:29 PM. Reason: wrong link

  61. #261
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    This looks like a simple VLOOKUP solution, but the Greek character set is causing me fits. Anyone want to try this one?

    http://www.excelforum.com/excel-gene...ml#post4222471

  62. #262
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Call in the Cavalry - 2015

    I can concatenate multiple results into a cell... I can get an INDEX-MATCH to return unique results, but I'm struggling to do both. I really do have to go and earn some money... Any takers (of the OP's query, not my money!!!)?

    http://www.excelforum.com/excel-form...pe-column.html

  63. #263
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Call in the Cavalry - 2015

    Am I missing something on what this OP wants?

    I think s/he wants cascading updates from a Validation Table, but I just can't understand the question.

    http://www.excelforum.com/excel-form...alidation.html

  64. #264
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    This user is having trouble in Excel 2016. Chart formatting information does not seem to want to save with the file. I cannot recreate the problem in an earlier version of Excel. http://www.excelforum.com/excel-char...ing-stick.html

  65. #265
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Call in the Cavalry - 2015

    This is my personal issue
    http://www.excelforum.com/excel-form...ml#post4226051
    At the moment I get stuck and could not get it around.

  66. #266
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Call in the Cavalry - 2015

    Some quick and easy VBA points for someone here, I'm not up to it right now.
    http://www.excelforum.com/excel-form...ml#post4224860

  67. #267
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    Hi,

    With regards this Thread
    http://www.excelforum.com/excel-prog...ml#post4226942

    I thought from my knowledge and Googling i could explain the difference with these 3 code lines easily.

    1 Set WB = Workbooks("myfile.xlsm")

    2 Set WB = Workbooks.Open(ThisWorkbook.path & "\myfile.xlsm")

    3 Set WB = GetObject(ThisWorkbook.path & "\myfile.xlsm")

    I think i almost have it. 1 is simple. 2 and 3 appear to work in a very similar way. Where i am stuck is that the main difference with code line 3 is that, although the Workbook appears in the VB development window, I cannot see the Spreadsheet file. So to manipulate it I must use VBA code. I have found lots of links in the internet telling me how to make this file visible. But they are not working for me.

    CAN ANYONE TELL ME HOW TO MAKE THIS FILE visible after i open it through
    GetObject(ThisWorkbook.path & "\myfile.xlsm")

    Thanks
    Alan

    P.s. i am using XL 2007 currently.
    P.p.s. The first code at this Post
    http://www.excelforum.com/excel-prog...ml#post4227458
    may help to demo the issue ( and there are lines commented out in that code that Googling told me should make that File visible in case 3).

  68. #268
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Call in the Cavalry - 2015

    @Doc

    'manually': Ribbon / View / unhide

    VBA: workbooks(3).windows(1).visible=true

  69. #269
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    @snb
    Hi snb
    I could not find the manual way. Possibly something lost on the translation to my German Excel, and/ or ( most likely! ) I missed the point.... clicking on a Ribbon I can’t see is puzzling me.
    I got to the code line, variations of your suggested, ( I happened to have 4 workbooks open at the time):
    Workbooks(4).Windows(1).Visible = True
    OR
    Workbooks.Item(4).Windows(1).Visible = True

    I guess this is telling me that VBA is giving the item number of the Workbook in the order of it being opened. (And in this case I only have one Window open for the Workbook )
    Somewhere along the line I think I got close to this, which I find now also works..
    WB.Windows(1).Visible = True
    ( In fact I had in my code ( commented out ) WB.Parent.Windows(1).Visible = True, which i googled,
    https://msdn.microsoft.com/de-de/lib.../gg251785.aspx
    , but which does not work !?! )

    Thanks snb for getting me there on this one
    Appreciate it
    Alan
    Last edited by Doc.AElstein; 10-28-2015 at 07:00 PM.

  70. #270
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Call in the Cavalry - 2015

    Or
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by snb; 10-29-2015 at 05:28 AM.

  71. #271
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Call in the Cavalry - 2015

    Hi snb
    Quote Originally Posted by snb View Post
    Or .....
    _ ..stimt!! Correct, got it, beides.
    Many Thanks for the extra Hinweise.
    Alan

    P.s.
    This looks fun to put at the end of somenones code
    ThisWorkbook.Windows(1).Visible = False
    Maybe one way to encourage an OP to Feedback
    Last edited by Doc.AElstein; 10-29-2015 at 04:40 PM.

  72. #272
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Call in the Cavalry - 2015

    Das freut mich. LG.

  73. #273
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Call in the Cavalry - 2015

    Disregard this post
    Last edited by alansidman; 11-03-2015 at 06:31 PM.

  74. #274
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2015

    Can anyone offer a suggestion on this 1? I have a feeling it will need VBA
    http://www.excelforum.com/excel-gene...ml#post4232883

  75. #275
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    OP wants to do a date-wise lookback across horizontal records. Each record is 1 row by 4 columns. Wants return to show the complete record match. Managed to do this for a single record match, but OP anticipates multiple returns and wants each field to be concatenated. I can’t even set up formula for this one that enables concatenating UDFs to work.

    This looks like a job for VBAman … (or CS?)

    http://www.excelforum.com/excel-form...d-on-date.html

    Edit You can disregard this one. OP has opted to manually concatenate.
    Last edited by FlameRetired; 11-06-2015 at 06:52 PM.

  76. #276
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Call in the Cavalry - 2015

    I have this half solved. Need some assistance on the other requirement. Don't have time to spend on working this one out.

    http://www.excelforum.com/excel-prog...tock-gaps.html

  77. #277
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Call in the Cavalry - 2015

    Just not my day. Here's another one that I started but could not finish.

    http://www.excelforum.com/excel-prog...nd-column.html

  78. #278
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Call in the Cavalry - 2015

    anyone have free time to answer this one
    http://www.excelforum.com/excel-prog...g-a-macro.html

    posted something but OP much later now my head hurts trying to figure out what the OP is asking for now
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  79. #279
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-gene...-in-excel.html

    This OP is looking for implentations of "hashing" algorithms in Excel. The internet seems to have several possible solutions. One that we found appears to be VB that would work if the OP knew how to import the stand alone VB class into VBA. He has no VB experience, and I do not have much experience importing a stand alone VB class into VBA. I don't know if there are better solutions out there (I was kind of hoping the OP would be able to perform the internet searches himself) or if there are a few simple steps to importing the code we have found into VBA. If someone wants to look and see if they have anything to contribute, at this point all I can seem to contribute is "here let me google that for you" kind of suggestions.

  80. #280
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Sounds like this requires a macro search routine

    http://www.excelforum.com/excel-form...hlighting.html

  81. #281
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Any help here with referencing spreadsheets in VBA with Excel 2003?

    http://www.excelforum.com/excel-form...ched-from.html

  82. #282
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

  83. #283
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the Cavalry - 2015

    After taking a second look, I new I didn't read this right.

    Any help would be appreciated

    http://www.excelforum.com/excel-form...ml#post4248017
    HTH
    Regards, Jeff

  84. #284
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Call in the Cavalry - 2015

    I don't see how this can be done by formulae alone. Anyone interested in a VBA challenge?
    http://www.excelforum.com/excel-form...ncatenate.html

  85. #285
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2015


  86. #286
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Call in the Cavalry - 2015

    I have answered the OPs original question (test whether or not a range of numbers is in ascending order) using SUMPRODUCT and an offset range. However, the OP has now let it slip that there can be blank cells. I can't figure it out...

    http://www.excelforum.com/excel-form...ncreasing.html

  87. #287
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Call in the Cavalry - 2015

    The most complicated IF structure that I have never seen before!

    http://www.excelforum.com/excel-form...ml#post4251493

    Is there someone willing to jump in?

  88. #288
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Call in the Cavalry - 2015


    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  89. #289
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Call in the Cavalry - 2015

    Too much finance for my brain to handle

    http://www.excelforum.com/excel-form...-analysis.html

  90. #290
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Call in the Cavalry - 2015

    Somebody want some of this? I've hit a wall with formulas.

    http://www.excelforum.com/excel-gene...2-columns.html

  91. #291
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Call in the Cavalry - 2015

    http://www.excelforum.com/excel-char...challange.html I don't know how to do "custom tool tips for chart data points". I can google the query for him, though it would probably be faster for him to google it himself. Someone here may have a better suggestion than just "google it".

  92. #292
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2015

    Serbian English problem

    I don't think the basic question is too much of a problem but understanding English is. We have exchanged a few private messages trying to get him/her to start a new thread but to no avail.

    http://www.excelforum.com/private.ph...pm&pmid=217683


    click on the * Add Reputation if this was useful or entertaining.

  93. #293
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Call in the Cavalry - 2015

    @tony h

    The link you provided appears to be invalid. Link to the Thread please.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  94. #294
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Call in the Cavalry - 2015

    Corrected Link below
    Quote Originally Posted by tony h View Post
    Serbian English problem

    I don't think the basic question is too much of a problem but understanding English is. We have exchanged a few private messages trying to get him/her to start a new thread but to no avail.
    http://www.excelforum.com/excel-prog...matically.html

  95. #295
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the Cavalry - 2015


  96. #296
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2015

    I doubt this is do-able, but putting it outh there for others to have a go at...
    http://www.excelforum.com/excel-new-...-question.html
    data is VERY messy

  97. #297
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Call in the Cavalry - 2015

    @Ford: maybe post in the 2016 CITC?

  98. #298
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Call in the Cavalry - 2015

    we have 1 for 2016?
    I was just thinking about making 1, Trevor

    edit: just found it lol thanks
    Last edited by FDibbins; 01-13-2016 at 06:57 PM.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Call in the cavalry -- need help solving this thread-prior to 2013
    By teylyn in forum The Water Cooler
    Replies: 821
    Last Post: 01-06-2015, 08:01 PM
  2. Call in the Cavalry - 2013
    By FDibbins in forum The Water Cooler
    Replies: 457
    Last Post: 01-06-2015, 08:00 PM
  3. Call in the Cavalry - 2014
    By JBeaucaire in forum The Water Cooler
    Replies: 351
    Last Post: 01-06-2015, 07:56 PM
  4. Call in the Cavalry too long now so teach me something...
    By MarvinP in forum The Water Cooler
    Replies: 0
    Last Post: 12-26-2014, 04:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1