Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: Sum of last few available lines with data

    I think if you change
    (A1:Z1<>"")
    to
    (A1:Z1>0)
    it will work
  2. Re: Adding 50 to a number then rounding up to nearest 100 (not down)

    =roundup(a1+50,-2)
  3. Replies
    14
    Views
    626

    Re: Count If function

    It can be done with SUMPRODUCT as above (or SUMIFS if you're using 2010). The advantage of a pivot table is that it doesn't require you to maintain a list of all possible categories. It depends on...
  4. Replies
    14
    Views
    626

    Re: Count If function

    I would think that the most efficient way to do this would be to create a pivot table.
  5. Re: VBA Saving a file using a filename as a specified cell and as a CSV file

    Sorry, didn't look at your code properly - I think the problem might be with trying to apply SaveAs to a single worksheet.
  6. Re: VBA Saving a file using a filename as a specified cell and as a CSV file

    Try

    Sheets("CSV").Select.SaveAs Filename:= _
    "X:\Applications\1-Inbound\" & sfilename & ".csv", FileFormat:=xlCSV, _
    CreateBackup:=False
  7. Replies
    9
    Views
    225

    Re: Compensation / Salary Data Lookup

    Welcome to the board.

    You can use the MATCH function with a final argument of 1 to pull the position of the step that is below the current salary - then add 1 to get the position of the step...
  8. Replies
    7
    Views
    1,407

    Re: Interview from a CFO

    I would expect the questions would be CV related (any weak spots that need explaining, and anything especially strong as well). Prepare questions that demonstrate your interest in the company - be...
  9. Re: Can you chart a series with GetPivotData (or something like?)

    Could you do it with INDEX and MATCH? Use GetPivotData for the find argument in MATCH, and pull the whole row in INDEX?
  10. Re: Descriptive Variables, Descriptive Comments, or Both?

    I use a version of the Hungarian naming convention, and a fair number of comments. I always comment if I've nicked a bit of code from someone on here - including the thread URL.
  11. Re: Help - macro for importing csv file into Excel and format

    Have you tried recording a macro while you complete those steps?
  12. Re: Can you chart a series with GetPivotData (or something like?)

    Could you not just use a pivotchart?
  13. Re: Creating pivot table from .csv, but date formatted as text

    bump
  14. Replies
    2
    Views
    280

    Re: conditional format between dates

    Try using Formula Is within conditional formatting, and setting it to:

    =OR(B2-A2<=1,C2-A2<=1)

    Then use the format painter to copy the formatting down.
  15. Re: Line Graph Problem: Remove Line Going To Zero

    A chart won't display anything if the cell shows #NA, so you can use IF so that if the value is 0, the cell displays #NA.
  16. Creating pivot table from .csv, but date formatted as text

    I have a .csv file with about 400,000 lines. I'm using Excel 2003, so can't open the file in Excel. I need to create a pivot table from the file.

    Currently we create an Access database, and then...
  17. Replies
    0
    Views
    682

    Multi-criteria vlookup within VBA

    Hi everyone, I'm being a bit dense this afternoon, so would appreciate your help.

    I have a spreadsheet with three columns. Column A is Brand, column B is Channel, column C is Measure. I'm trying...
  18. Thread: iPad 2

    by cornflakegirl
    Replies
    21
    Views
    1,830

    Re: iPad 2

    Has she actually asked for a pink one? Ownership of a womb doesn't automatically restrict ones colour palette...
  19. Re: Cell automatically recalculating data entered in that cell

    Way to freak a girl out! ;)

    [EDIT: Just got the reference. Sorry. Been a long day!]
  20. Re: Cell automatically recalculating data entered in that cell

    You could do it with VBA, eg:


    Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("A1")) Is Nothing Then
    Application.EnableEvents = False
    Target.Value...
  21. Thread: Equation

    by cornflakegirl
    Replies
    2
    Views
    516

    Re: Equation

    You've got four variables - you can't just give a value to one and have all the rest fall out.

    If you enter a value for D, L, H and S, you'll get a value for BP.
    If you enter a value for BP and...
  22. Replies
    6
    Views
    398

    Re: this will be a fun one!

    Can you use a helper column that contains the numbers summed from the bottom? Then you could adapt Biff's formula.
  23. Replies
    9
    Views
    8,017

    Re: create random postcodes for testing

    It's not going to generate you any postcodes of the form XX# #XX eg CB1 1AB. Which will probably exclude a significant proportion of addresses (every postcode I've had has been in this form).

    (I...
  24. Thread: drag

    by cornflakegirl
    Replies
    6
    Views
    384

    Re: drag

    What is your formula?
  25. Replies
    20
    Views
    957

    Re: Need Help With A Formula . .

    Oh, that's nice.

    (Although I think the DOLLARFR bit is actually a step further than what EP requested?)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4