Please share profile on ja...@nestarit.com
Direct contact number: (201) 448 1184
This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH LLC* and we have
an immediate requirement with our client where we have excellent hold and
can close the positions pretty quick. If you find yourself comfor
Thanks please
It has helped so much.
Thanks
Ayoub
On 5 December 2017 at 16:02, Paul Schreiner wrote:
> OK, you could use a macro like:
>
> Sub Gen_List()
> Dim nRows, nRow, dRow, inx
> dRow = 0
> nRows = Application.WorksheetFunction.CountA(Range("A:A"))
> For nRow = 1 To nRow
OK, you could use a macro like:
Sub Gen_List()
Dim nRows, nRow, dRow, inx
dRow = 0
nRows = Application.WorksheetFunction.CountA(Range("A:A"))
For nRow = 1 To nRows
For inx = 1 To 10
dRow = dRow + 1
Cells(dRow, "B").Value = Cells(nRow, "A").Value
Column A has fixed numbers. e,g A1=234, A2=323 A3=423424.
Column B should pick A1 and repeat it 10 times then move to A2 repeat it
also 10 times
e.g B1=234, B2=234, B3=234, B4=234, B5=234, B6=234, B6=234, B7=234, B8=234,
B9=234, B10=234, B11=323, B12=323
Thanks
On 5 December 2017 at 15:26, Paul S
Please elaborate.
I understand that you have random numbers in column A.how many? do they change
when the workbook calculates? or are they "fixed"?
What do you mean: " I want column B to pick from A"Do you want to randomly
select a random number from column A?
then: "fill one number 10 times"Wha
Sure, the "trick" is that you have to start at the last row and work your way
"up".
because otherwise, when you delete a row, the "next" row moves up into the
deleted position, then the loop would skip over that record.
By starting at the bottom, the row that moves up has already been processed..
Dear All,
I have column A that contains random numbers,
I want column B to pick from A fill one number 10 times, thn pick the
second fill it 10 times etc,
Any help will be much appreciated
--
**In sun set years education is not associated with standard of living and
medical care access; it is the
Hi friends,
Please find the below video to learn how to use multiple lookup value in
single vlookup formula.
https://youtu.be/SpmnZmfJSVo
Regards
Prabhu.R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo