I want to calculate cummulative revenue for current quarter + previous
3 quarters in an Access Table. The table has Revenue field and Fiscal
Quarter Code listed as FY2008Q1, FY2008Q2, FY2008Q3, FY2008Q4,
FY2009Q1 and so on.. Is there a dynamic query which can give me
rolling 4 quarter cummulative
Hi JsinSk,
You should have another look in the OP's data structure since the data
begins with three digit numeric value. So changing the cell format won't
cause any change in data visibility since excel treat that as text data
because of three digit numeric value in the beginning 000:00:00. Your
Hi All,
I am trying to model user adoption based on a s-curve adoption rate
for cities. So I have a simple s-function that shows town growth and
I want to create a S-function for user growth based on the number of
towns.
The problem I am finding is that when the town jumps from let's say 1
to 2,
I have a spreadsheet with multiple macros and userforms running perfectly in
Excel 2003 across 10 different sites with 10 different sets of information
in the tables - but there are various improvements that have been requested
and I was looking for some advice on redeploying a revised spreadshe
Dear Sajid Memon
Thanks you
Regards
Manoj
On 3/28/11, SAJID MEMON wrote:
>
> Dear Manoj
> you should visit tallysolutions.com for learn online
> tutorial by your tallyERP.9 serial number. From there you can learn better.
>
> Regards
>
> Sajid Memon
>
>> Date: Sun, 27 Mar 2011
STDEV(i), Timevalue will not work as it can never be greater than 24
hours. Use Value, and then change the format to [hhh]:mm:ss
On Mar 28, 7:37 pm, JsinSk wrote:
> If you can change the format of your times it should work. I used
> hh:mm:ss and it works.
>
> On Mar 28, 6:59 am, Bhushan Sabbani
Select ten cells starting from B2 to B11, starting from B2. Press F2,
and paste =LARGE(VALUE(RIGHT(B2:B886,8)),ROW(B2:B11)-1) and hit
CTRL+SHIFT+ENTER
On Mar 28, 3:59 pm, Bhushan Sabbani wrote:
> Dear All,
>
> I am facing the problem in the formula of the large to find the top 10.
>
> Here i am a
Select ten cells starting from B2 to B11, starting from B2. Press F2,
and paste =LARGE(VALUE(RIGHT(B2:B886,8)),ROW(B2:B11)-1) and hit
CTRL+SHIFT+ENTER
Sam
On Mon, Mar 28, 2011 at 4:29 PM, Bhushan Sabbani wrote:
> Dear All,
>
> I am facing the problem in the formula of the large to find the top 1
Both ways worked perfectly, but in =MID(B2,2,SEARCH(" ",B2)-2) i had to put
=MID(B2,1,SEARCH(" ",B2)-1) in order to give me full word.
Thank you both, very much for your help. :), excel-lent as always!
2011/3/24 Ms-Exl-Learner .
> Try this…
>
>
> =IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),F
Yes but isn´t that available only to office2010? i use office2007 at work i
think it´s retro compatible but only in view form right?
Anyway, i have to do a different way now, they decided they what 3 separate
files, a database for each report, and my problems now are different, i´m
dealing with pr
Hi,
You can use custom sort option to sort...
Regards,
Raghunandan M N...
9880379034
On Mon, Mar 28, 2011 at 4:29 PM, Bhushan Sabbani wrote:
> Dear All,
>
> I am facing the problem in the formula of the large to find the top 10.
>
> Here i am attaching the sample file for the reference.
>
> Tha
If you can change the format of your times it should work. I used
hh:mm:ss and it works.
On Mar 28, 6:59 am, Bhushan Sabbani wrote:
> Dear All,
>
> I am facing the problem in the formula of the large to find the top 10.
>
> Here i am attaching the sample file for the reference.
>
> Thanks in adva
your data in B columns are TEXT data, not time data / numbers data
so you can pass into LARGE function
please try this array formula
=TEXT(LARGE(TIMEVALUE(RIGHT(B2:B886,8)),ROW(1:10)),"[hhh]:mm:ss")
array formula written on one_column (10 cells) at once !!
On Mon, Mar 28, 2011 at 5:59 PM, Bhus
PFA file. Hope it serve the purpose.
Regards,
C.G.Kumar
On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i) wrote:
> oops, the attachment
>
>
>
> On Sun, Mar 27, 2011 at 9:35 AM, STDEV(i) wrote:
>
>> please find attached
>> and see if it helps
>>
>> best regards
>> siti Vi
>>
>>
>> On Sat, Mar 2
Dear Manoj
you should visit tallysolutions.com for learn online tutorial
by your tallyERP.9 serial number. From there you can learn better.
Regards
Sajid Memon
> Date: Sun, 27 Mar 2011 16:02:12 +0530
> Subject: $$Excel-Macros$$ Any tally groups
> From: kmrmanoj1...@gmail.c
Thanks, Ashish.. I've sortout this one..
thanks A Lot Bro..!! :-)
On Mon, Mar 28, 2011 at 11:24 AM, ashish koul wrote:
> note: before you start slide show run StartEvents macro in ppt
>
> On Mon, Mar 28, 2011 at 11:18 AM, ashish koul wrote:
>
>> hi deepak
>>
>> try this method see if it helps
16 matches
Mail list logo
