Hi Expert,
we need your help we have attached excel file.
actuall i have data based on Wid and i have to update in attached as
mentioned below based on formula
WID Months
1 April
1 May
1 June
1 July
1 August
1 September
1 October
1 November
1 December
hi
what is WID..
if you want to file Apr-Mar below then select range B2:B13, after that
using mouse take your cursor to bottom end of right side till it becomes
dark black plus sign & then double click on it,.
+
*I did not do this for you. God is here working through me for you.*
On Wed,
Check this...
is this what you are looking for?
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 3:38 PM, Vaibhav Joshi wrote:
> hi
>
> what is WID..
>
> if you want to file Apr-Mar below then select range B2:B13, after that
> using mouse take
hi,
WIid is Whole seller unique id and i have to reflect total months from
april to march individully based on WID
so kidnly help me
On 24 December 2014 at 15:38, Vaibhav Joshi wrote:
> hi
>
> what is WID..
>
> if you want to file Apr-Mar below then select range B2:B13, after that
> using mous
try this
=TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),"")
On Wed, Dec 24, 2014 at 3:46 PM, Raj Kumar wrote:
> hi,
>
> WIid is Whole seller unique id and i have to reflect total months from
> april to march individully based on WID
>
> so kidnly help me
>
> On 24 December 2014 at 15:38, Vaibhav
Try formula given by Ashish Koul, its working great!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 3:55 PM, ashish koul wrote:
> try this
>
> =TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),"")
>
> On Wed, Dec 24, 2014 at 3:46 PM, Raj Kumar wr
Hi,
I'd like to use the following array formula to sort numerical values rather
than text. Is anybody able to convert it for me?
=INDEX(tbl, SMALL(IF(SMALL(IF(COUNTIF($B$7:B7, tbl)+ISBLANK(tbl)=0,
COUNTIF(tbl, "<"&tbl)+1, ""), 1)=IF(ISBLANK(tbl), "", COUNTIF(tbl,
"<"&tbl)+1), ROW(tbl)-MIN(ROW(t
--
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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
Hi
Use follo formula, its not an array one..
=SMALL(tbl,ROWS($B$2:B2))
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 5:15 PM, Eddie wrote:
> Hi,
> I'd like to use the following array formula to sort numerical values
> rather than
also this array formula work for me..
=INDEX(tbl, SMALL(IF(SMALL(IF(COUNTIF($B$7:B7, tbl)+ISBLANK(tbl)=0,
COUNTIF(tbl, "<"&tbl)+1, ""), 1)=IF(ISBLANK(tbl), "", COUNTIF(tbl,
"<"&tbl)+1), ROW(tbl)-MIN(ROW(tbl))+1), 1), MATCH(MIN(IF(COUNTIF($B$7:B7,
tbl)+ISBLANK(tbl)>0, "", COUNTIF(tbl, "<"&tbl)+1)),
The original array formula doesn't work for me with numbers. it only lists
the lowest value in the returned list. :(
On Wednesday, 24 December 2014 11:45:04 UTC, Eddie wrote:
>
> Hi,
> I'd like to use the following array formula to sort numerical values
> rather than text. Is anybody able to con
Your original formula will also work but you need to start from cell B8 &
downward...
Check again...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 5:35 PM, Eddie wrote:
> The original array formula doesn't work for me with numbers.
check this excel file..
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 5:44 PM, Vaibhav Joshi wrote:
> Your original formula will also work but you need to start from cell B8 &
> downward...
>
> Check again...
>
> Cheers!!
>
> +
> *I did n
Many thanks Vabz.
I've got it working. The problem was that I had formula in the 'blank'
cells.
I've now restricted the list to cells containing values which works.
Thanks again.
On Wednesday, 24 December 2014 11:45:04 UTC, Eddie wrote:
> Hi,
> I'd like to use the following array formula to s
Dear experts team,
I required formula to extract data as par my criteria but it is very
complex criteria but my thought is that everything is possible in
excel.
Appreciate the help.
Let us know in case of any further assistance.
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Dear All our experts members,
Wish u all A Merry Christmas
May the Joys of the season
Fill your heart with goodwill and cheer.
May the chimes of Christmas glory
Add up more shine and spread
Smiles across the miles
Today & In the New Year.
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Merry X'Mas to All..Happy holidayz
[image: Inline image 1]
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 24, 2014 at 7:26 PM, amar takale wrote:
> Dear All our experts members,
>
> Wish u all A Merry Christmas
> May the Joys of the season
> Fi
[?][?][?][?][?][?][?][?]
[?][?][?][?][?][?][?][?]
Merry Christmas
On Wed, Dec 24, 2014 at 7:41 PM, Vaibhav Joshi wrote:
> Merry X'Mas to All..Happy holidayz
>
> [image: Inline image 1]
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, D
Hello Associate,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Jr. Net Developer with SSIS, SSRS and SQL experience*.
*Plymouth,
MN*. Please find below the job description for the same and revert back to
me with your consultant updated profile and cont
Wish You All Merry X'Mas.
On Wed, Dec 24, 2014 at 7:26 PM, amar takale wrote:
> Dear All our experts members,
>
> Wish u all A Merry Christmas
> May the Joys of the season
> Fill your heart with goodwill and cheer.
> May the chimes of Christmas glory
> Add up more shine and spread
> Smiles acros
Hello Associate,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Jr. Net Developer with SSIS, SSRS and SQL experience*.
*Plymouth,
MN*. Please find below the job description for the same and revert back to
me with your consultant updated profile and cont
Hello Mr.Vaibhav
As per trial mail, you solved my function query to display data on matching
code, but could you please edit this function to display only those data
which matching with code & Date, example is mention in attached sheet.
Regards.
Ashish Bhalara
9624111822
P*Please do not print thi
22 matches
Mail list logo