Search:

Type: Posts; User: KJP0422; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    228

    Re: Cell Reference in a formula

    Can anybody set me in the right direction. I have been working on this formula for 2 days now with no luck?
  2. Replies
    4
    Views
    228

    Re: Cell Reference in a formula

    Spreadsheet contains following:

    Column A = Supplier Name ABC
    Column B = Cell Address G11
    Column C = Old Value Soup
    Column D = New Value Nuts
    Column E THIS IS WHERE I NEED...
  3. Replies
    4
    Views
    228

    Cell Reference in a formula

    I have a file that gives me a list of all cells that have been changed. In the file it references Cell Address as a column of volumes. I need to go to that cell in the original file and copy...
  4. Sticky: Re: Here are 30 reasons why you should be considering Power BI

    Hi Matt,

    I understand your comments and I am in the process of learning all of it...... It would be so nice though to see similar functionality listed side by side in example: VLOOKUP then the...
  5. Sticky: Re: Here are 30 reasons why you should be considering Power BI

    Could someone out there write a book or something that shows you an Excel Function and what its DAX Counterpart is! I would buy it immediately
  6. Replies
    0
    Views
    311

    Cross Reference DAX - excel Functions

    Can anyone point me to a site where I can compare Excel Functions to DAX Functions?
  7. Replies
    3
    Views
    505

    Re: Newbie Question

    Thank you for the response. I am not doing this in Excel but in Power BI. There is a link icon but it does not allow me to indicate "In this Document". I really would appreciate any response.
    ...
  8. Replies
    3
    Views
    505

    Newbie Question

    I am new to Power BI and I am ever so happy to see that Mr. Excel has a forum. Makes my heart sing.

    I have a page with some static Column/Line Graphs in Power BI. What I want to be able to do...
  9. Re: Formula Help - Identify First and Last Row

    Thank you so much. It's working! :laugh:
  10. Formula Help - Identify First and Last Row

    I have a spreadsheet with numerous lines of Data. Is there a way to find out the first row instance of a text phrase, lets say "Assembly" for grins and then the last row where it finds the same...
  11. Thread: Help AND

    by KJP0422
    Replies
    6
    Views
    245

    Re: Help AND

    I have been pulled off this task for the remainder of today. I will look at this from home over the weekend and let you know what I did. Thank you all your help is very much appreciated.
  12. Thread: Help AND

    by KJP0422
    Replies
    6
    Views
    245

    Re: Help AND

    Yes they are short text data types. I followed your suggestion and its giving me values but not the correct ones. Thank you for your prompt response. I am impressed!

    SELECT...
  13. Thread: Help AND

    by KJP0422
    Replies
    6
    Views
    245

    Help AND

    I have a table that displays country code as a numeric value. I need to summarize for USA - Code 104, CAN - Code 102, MEX - Code 209

    All other countries have different codes. I have tried...
  14. Replies
    8
    Views
    6,988

    Re: Rolling 12

    I have been working on this formula for 2 days now. Someone please help me. I have an access database that has fields for Accounting Date, P/N, P/N Description, Quantity and Cost. My goal is...
  15. Replies
    0
    Views
    124

    A formula to build a formula

    I have a series of graphs that depict different account categories by day and by month. These graphs show daily budget and daily actual. August would have 31 Plot Points with a bar graph...
  16. Thread: onChange Event

    by KJP0422
    Replies
    3
    Views
    790

    Re: onChange Event

    Thank you, Thank you, Snoopy Happy Happy Dance going on now. I would have never figured that one out. I modified to the following and it is working as anticipated.

    Private Sub...
  17. Thread: onChange Event

    by KJP0422
    Replies
    3
    Views
    790

    onChange Event

    Hello,

    I am using Excel 2010 and I am trying to add an OnChange Event onto the sheet where I need to increase the font size. The cell R29 (merged cell extends to V29) holds an email address and...
  18. Replies
    2
    Views
    131

    Re: Date Formatting

    Perfect. Thanks for the formula and more importantly Thanks for you service. My father was also in the 101.
  19. Replies
    2
    Views
    131

    Date Formatting

    How would I get this to formula to add "CP - " and the month name from the EOMONTH function

    My desired end result would read CP - 1: Apr assuming the current month = May

    =EOMONTH(NOW(),-1)
    ...
  20. Replies
    5
    Views
    561

    Re: Access Date Issue

    Thanks all, but I am still having problems with this formula. My goal is to sum the quantity by item for a rolling 12 month period. So there will be an IIF statement included as well. I entered...
  21. Replies
    5
    Views
    561

    Access Date Issue

    In excel if I want to find the last day of the current month I can use the following formula

    =EOMONTH(TODAY(),0)

    I have an access database with a table that contains , Accounting Date,...
Results 1 to 21 of 21