Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: How to use Dsum with two criteria

    Pl see this link
  2. Re: How to use Dsum with two criteria

    PL share workbook showing expected result.
  3. Re: dropdown list in alphabetical order data validation...

    One example.
    Name list derived from formula is in N4:N12. Some cells say N8: N12 are blank. Formula is below for Data Validation.
    In the drop down list you will see only names in N4:N7 (Cells...
  4. Replies
    8
    Views
    313

    Re: Issue With deleting rows

    Instead of Sheet2 add the column Descrizione in Sheet1. So that when rows are deleted Descrizione column data also updated.
  5. Replies
    8
    Views
    299

    Re: Reference Cell not Updating

    Since only columns are inserted, it is sufficient to name the columns instead of each cell. Refer to range name and row

    Workbook Book2
    Rage name val
    Row number 3
    =INDEX(Book2.xlsx!val,3)
    ...
  6. Replies
    8
    Views
    329

    Re: Issue with a formula

    May be this.
    In F2 the cop down.

    =IFERROR(AGGREGATE(14,6,$C$2:$C$9/($A$2:$A$9="Europe"),ROWS($F$2:$F2)),"")
  7. Re: Find and replace whole cell by substring

    Try this code


    Sub FindAndReplaceing()
    Dim NameListWB As Workbook, thisWb As Workbook
    Dim NameListWS As Worksheet, thisWs As Worksheet
    Dim i As Long, lRow As Long
    Dim Frng As...
  8. Re: VBA to count number of words in cell

    Try this code

    Sub CountWords()


    Dim TotWds As Long
    Dim cel As Range


    For Each cel In Range("p1:p" & Cells(Rows.Count, "A").End(xlUp).Row)
  9. Replies
    13
    Views
    428

    Re: Unique List From 2 Columns

    If numbers in both list are required.


    <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
    A
    B
    C
    D
  10. Replies
    13
    Views
    428

    Re: Unique List From 2 Columns

    Formula given in previous post does not work properly.
    Here is the revised formula.

    ...
  11. Replies
    13
    Views
    428

    Re: Unique List From 2 Columns

    <tbody>
    A
    B
    C
    D


    32
    11
  12. Replies
    13
    Views
    428

    Re: Unique List From 2 Columns

    In column C you need missing numbers of column A.
  13. Re: calculate data from another spreadsheet

    99,99 is due to format of cells. Actually it is 9999.
    Try this

    =COUNTIF('2014'!O3:O83,"<="&999)
  14. Re: Sum Numbers up to Number in Top Column

    Thanks for feedback
  15. Re: Sum Numbers up to Number in Top Column

    Try this. In C4 then dragged across.

    ...
  16. Replies
    10
    Views
    381

    Re: Highlight Cell Range

    Work sheet event is used.


    Range used is A16:A22 . Change if required.
    Code

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)


    Dim rng As Range, Cel As Range
  17. Replies
    2
    Views
    162

    Re: Sick Leave

    Pl upload a sample data or file.
  18. Replies
    11
    Views
    433

    Re: Index , Vlookup Average Formula

    Does all the dates in Row 1 and column K are in date format.
  19. Re: Formula that calculates using Inflation factors

    In post# 3 Data is only in Row2. In Formula I have added Row 3 also.
    In Row 3 You can add data for Code2.
    If more rows required,
    Then Row 4 for Code3.
    So on..
  20. Re: Formula that calculates using Inflation factors

    Data in Sheet1


    <tbody>

    A
    B
    C
    D
    E
  21. Re: Having trouble with a For Loop and counting using variables

    Code for macro

    Sub WriteData()
    Dim Clm As Long, Ro As Long, TA As Long, TB As Long


    For Ro = 1 To 3
    For Clm = 1 To 3
    Sheets("NewSheet").Range("B5").Offset((Ro - 1) * 47 + (Clm - 1)...
  22. Replies
    2
    Views
    223

    Re: formula to add sales

    DATA
    ROW B C date E
    salesman sales date HELPER
    3 man1 2 01-05-2018 1
    4 man2 3 02-05-2018 1
    5 man1 4 01-04-2011 1
    6 man3 2 01-03-2017 1
    7 man1 4 02-05-2009 1
    8 man1 4 01-05-2017 0
  23. Replies
    3
    Views
    227

    Re: Formual Help - Duplicate Dates

    Post an image of sample data and results required.
  24. Replies
    13
    Views
    432

    Re: List Nth item from a range.

    Why UDF. Worksheet formulas are sufficient.
    For 5th item

    =INDEX(A2:P2,5)

    For last but 3rd item

    =INDEX(A2:P2,COLUMNS(A2:P2)-2)

    For 5th item
  25. Re: Sumproduct combined with a condition of subject to maximum

    To understand ARRAY formulas
    link
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4