Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    3
    Views
    95

    Re: Change Coulour if gender is female

    Hi,

    You do need to have each name in a cell ...

    If your constraint is to keep your current sheet as it is ....

    Then you can replicate on a new tab you current sheet ... and generate clean...
  2. Re: Template to be save in simple worksheet.

    Hello,

    If I understand your request ... you need to Copy Paste Values which can be performed as file is saved as new file ...

    Hope this will help
  3. Replies
    6
    Views
    106

    Re: adding date using date() function

    For sure ... problem is solved ...:smile:
  4. Re: opying into cells if particular criteria is met

    Hello,

    You should take a look at AutoFilter ...

    Hope this will help
  5. Replies
    6
    Views
    106

    Re: adding date using date() function

    Hi,

    You could test

    = Edate(A1,12)

    Hope this will help
  6. Replies
    3
    Views
    104

    Re: Error In Expiry Date Formula

    You are welcome :smile:
  7. Replies
    3
    Views
    130

    Re: Responsive list / pivot - No VBA

    You are welcome ...:smile:
  8. Replies
    2
    Views
    103

    Re: rank.eq with multiple if conditions

    Hello,

    Have you tried an array formula with all your conditions ... ?
  9. Replies
    2
    Views
    89

    Re: Formula using indirect

    Hi,

    Your explanation is a bit confusing ...

    May be you should try =Offset(yourcell,-1,0) ...

    Hope this will help
  10. Replies
    5
    Views
    142

    Re: conditional formatting with time format

    You are welcome
  11. Re: Excel Lookup and SUMIF to data on Different Workbook **Help Please**

    With so many external links, you should probably take a look at Power Query

    https://www.howtoexcel.org/power-query/the-complete-guide-to-power-query/

    Hope this will help
  12. Replies
    6
    Views
    129

    Re: Top 10% Salaries

    For sure you have noticed Large() function deals with the ranking of amounts and not with the percentages ...

    You could test

    =A2>=Percentile(yourRange,0.9)

    Hope this will help
  13. Replies
    5
    Views
    142

    Re: conditional formatting with time format

    Have you tested the formula ...?
  14. Replies
    6
    Views
    129

    Re: Top 10% Salaries

    With the very ' skinny ' description you gave of your data structure ... quite tough to come up with a proposal ...

    Probably a helper column based on your Salary column would produce your expected...
  15. Re: Excel Lookup and SUMIF to data on Different Workbook **Help Please**

    Hi,

    Working with closed files does change several things ...

    see : https://exceloffthegrid.com/getting-values-from-a-closed-excel-workbook/

    Hope this will help
  16. Re: Use VBA to find which row on another worksheet contains a given value

    Hi,

    With the Find method ... :wink:

    see following link for explanation :

    https://www.ozgrid.com/VBA/find-method.htm

    Hope this will help
  17. Replies
    6
    Views
    129

    Re: Top 10% Salaries

    Hi,

    AutoFilter offers the possibility of extract what you are looking for ...

    Hope this will help
  18. Replies
    6
    Views
    101

    Re: Count number of unique codes in a column

    Glad you could fix your problem ...:smile:
  19. Replies
    18
    Views
    458

    Re: formatting a date

    You are welcome ...:smile:
  20. Replies
    1
    Views
    44

    Re: multiple total time by number

    Hello,

    Have you tried to format your Total Hours with [hh]:mm format ?
  21. Replies
    10
    Views
    118

    Re: Reverse VLOOKUP....Is it possible??

    You are welcome
  22. Replies
    10
    Views
    118

    Re: Reverse VLOOKUP....Is it possible??

    Glad you could fix your problem ...:smile:
  23. Replies
    6
    Views
    101

    Re: Count number of unique codes in a column

    Hi,

    Apparently 70'000 records is too much for Excel to swallow ...

    Would suggest to Insert a Pivot Table ... much safer ...
  24. Replies
    10
    Views
    118

    Re: Reverse VLOOKUP....Is it possible??

    Can you post the formula you are using ...

    Why are you pointing to " Reverse VLOOKUP " as the solution to your question ... ???
  25. Replies
    1
    Views
    69

    Re: countifs and also unique value

    Hello,

    Unfortunately ... your explanation is very confusing ...

    What is in Column C, in Column D, in Column E, in Column Q, in Column V ...?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4