# Search:

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

Page 1 of 6 1

1. ## Thread: How to use Dsum with two criteria

by kvsrinivasamurthy
Replies
12
Views
455

### Re: How to use Dsum with two criteria

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

by kvsrinivasamurthy
Replies
12
Views
455

### Re: How to use Dsum with two criteria

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

by kvsrinivasamurthy
Replies
23
Views
690

### 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. ## Thread: Issue With deleting rows

by kvsrinivasamurthy
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. ## Thread: Reference Cell not Updating

by kvsrinivasamurthy
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. ## Thread: Issue with a formula

by kvsrinivasamurthy
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. ## Thread: Find and replace whole cell by substring

by kvsrinivasamurthy
Replies
23
Views
450

### 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. ## Thread: VBA to count number of words in cell

by kvsrinivasamurthy
Replies
5
Views
150

### 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. ## Thread: Unique List From 2 Columns

by kvsrinivasamurthy
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. ## Thread: Unique List From 2 Columns

by kvsrinivasamurthy
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. ## Thread: Unique List From 2 Columns

by kvsrinivasamurthy
Replies
13
Views
428

<tbody>
A
B
C
D

32
11
12. ## Thread: Unique List From 2 Columns

by kvsrinivasamurthy
Replies
13
Views
428

### Re: Unique List From 2 Columns

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

by kvsrinivasamurthy
Replies
9
Views
394

### 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. ## Thread: Sum Numbers up to Number in Top Column

by kvsrinivasamurthy
Replies
13
Views
646

### Re: Sum Numbers up to Number in Top Column

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

by kvsrinivasamurthy
Replies
13
Views
646

### Re: Sum Numbers up to Number in Top Column

Try this. In C4 then dragged across.

...
16. ## Thread: Highlight Cell Range

by kvsrinivasamurthy
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. ## Thread: Sick Leave

by kvsrinivasamurthy
Replies
2
Views
162

### Re: Sick Leave

Pl upload a sample data or file.
18. ## Thread: Index , Vlookup Average Formula

by kvsrinivasamurthy
Replies
11
Views
433

### Re: Index , Vlookup Average Formula

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

by kvsrinivasamurthy
Replies
3
Views
134

### 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. ## Thread: Formula that calculates using Inflation factors

by kvsrinivasamurthy
Replies
3
Views
134

### Re: Formula that calculates using Inflation factors

Data in Sheet1

<tbody>

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

by kvsrinivasamurthy
Replies
1
Views
106

### 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. ## Thread: formula to add sales

by kvsrinivasamurthy
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. ## Thread: Formual Help - Duplicate Dates

by kvsrinivasamurthy
Replies
3
Views
227

### Re: Formual Help - Duplicate Dates

Post an image of sample data and results required.
24. ## Thread: List Nth item from a range.

by kvsrinivasamurthy
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. ## Thread: Sumproduct combined with a condition of subject to maximum

by kvsrinivasamurthy
Replies
5
Views
362

### 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