# Search:

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

Page 1 of 6 1

## Search: Search took 0.03 seconds.

by snjpverma
Replies
7
Views
480

### Re: sequence

Hi Marcela,
Your formula works great but I would like to kow why you used the part highlighted in Red at the end.
...

by snjpverma
Replies
7
Views
480

### Re: sequence

Thanks Marcelo. That's exactly what I needed.

by snjpverma
Replies
7
Views
480

### Re: sequence

thanks Demento for your support. the output is not numeric. It is an alphanumeric combination. Could you help me with the Index Match suggestion?

Thanks MickG for your support. But I am not much...

by snjpverma
Replies
7
Views
480

### sequence

assuming there is a team of 3 employees named a, b and c who have to be assigned a task as shown below.
They have to be assigned task in the same sequence as it comes. i.e. First task to a, second...
5. ## Thread: how to get Nearest higher value

by snjpverma
Replies
7
Views
271

### Re: how to get Nearest higher value

I tried the below but it doesn't work either. it seems to work only in Descending order. but my data is in ascending.

=INDEX(G:G,MATCH(A2,G:G,-1))
6. ## Thread: how to get Nearest higher value

by snjpverma
Replies
7
Views
271

### Re: how to get Nearest higher value

Hi Caleeco,
I tried Your formula and it gives me the nearest lower value instead of the higher one
7. ## Thread: how to get Nearest higher value

by snjpverma
Replies
7
Views
271

### how to get Nearest higher value

the data in Column G is in ascending order and I want the number from Column G which is closest to the value in A2 as my return value.

the below lookup function gives me the closest lower value...

by snjpverma
Replies
0
Views
149

If I put "East" Under the shops in my Output sheet, then all the rows which contains "East' in the Reference sheet should get pulled up. The problem is that Shops column contains input like this...

by snjpverma
Replies
6
Views
188

### Re: If function?

try this

=IF(A1>0,"a1 Loss","a1 Profit")
10. ## Thread: Not sure if nested IF, with AND, in addition to OR, unless there's a better way?

by snjpverma
Replies
15
Views
1,132

### Re: Not sure if nested IF, with AND, in addition to OR, unless there's a better way?

could you give a sample data? I am not sure what you are looking for

by snjpverma
Replies
4
Views
223

### Re: Formula not finding answer

try this
=IF(ISERROR(VLOOKUP(C2,A:B,2,FALSE)),"No match",VLOOKUP(C2,A:B,2,FALSE))
12. ## Thread: Need help with IF(MATCH formula

by snjpverma
Replies
3
Views
2,205

### Re: Need help with IF(MATCH formula

Welcome to the forum Zazybang,

Try this

=IF(COUNTIF(B6:B41,J6),"Yes","No")
13. ## Thread: IF, with more than 1 result option.

by snjpverma
Replies
19
Views
670

### Re: IF, with more than 1 result option.

fintail, your formula is getting cut everytime i guess. so if your formula contains < or > symbol, then keep a space around these symbols to avoid the formula from getting cut.
14. ## Thread: Vlookup with non specific value

by snjpverma
Replies
12
Views
733

### Re: Vlookup with non specific value

Caleeco, when you big a BigNum like this, the Lookup gives you the last value in the result array.
15. ## Thread: ISBLANK or IF statements

by snjpverma
Replies
3
Views
202

### Re: ISBLANK or IF statements

thanks for the update. glad it worked

by snjpverma
Replies
4
Views
119

17. ## Thread: Conditional formating specific number of cells based on another cell value

by snjpverma
Replies
4
Views
119

### Re: Conditional formating specific number of cells based on another cell value

select cell B1 and go to Conditional Formatting. Go to new rule> use a formula
and put this formula.

=COLUMN()<\$A1+2

Then copy B1 and paste the format to other cells where you want the same...
18. ## Thread: ISBLANK or IF statements

by snjpverma
Replies
3
Views
202

### Re: ISBLANK or IF statements

Try this

=IF(B1,B1-A1,TODAY()-A1)
19. ## Thread: how to fix the Grid lines missing in Excel

by snjpverma
Replies
1
Views
316

### how to fix the Grid lines missing in Excel

The Grid lines just not visible on a PC. following things I have tried.
1. The Gridlines are check-marked
2. I selected the whole sheet and gave "No fill" to Fill colour.
3. I went to Excel...

by snjpverma
Replies
8
Views
404

### Re: Array Formulas

This should work in such cases

=SUM(COUNTIFS(A2:A4,D2:D3,B2:B4,TRANSPOSE(E2:E3)))

by snjpverma
Replies
4
Views
280

### Re: Date Calculation

wow that's brilliant Aladin. I was trying this for so long.
This forum is full of genius people. Whenever I come here, I learn something new.

by snjpverma
Replies
4
Views
280

### Re: Date Calculation

any formula for this one? The only thing I want is: get the average of networkdays without the helper column C.
Column C is the networkdays from Date in column B to Yesterday.

This is basically...

by snjpverma
Replies
4
Views
280

### Re: Date Calculation

Just to highlight that the formula used column C has been mentioned at the bottom in Post #1 . It is a networkdays function which I use to find the difference from yesterday to the Date in Column B.

by snjpverma
Replies
4
Views
280

### Date Calculation

Hi Experts,

My data is as below. is the output in Column G possible without helper column C?

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col...
25. ## Thread: Match/index look up for text

by snjpverma
Replies
4
Views
94

### Re: Match/index look up for text

I think the name of your sheet 2 is "Payment", so you need to make the necessary changes. Also, you have made changes to your sheet 1 in post 1 above..

I made the below changes accordingly,
...
Results 1 to 25 of 150
Page 1 of 6 1