=IF(LEFT(A1,1)="B",LEFT(A1,6),"")
On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote:
>
> Hi Team,
>
> I need a formula to find anything starting from 5 in a cell and to take 6
> digit right of the cell starting from 5 as below.
>
> Eg.
>
> DataDesired Result
Hi Pete,
Just follow the following steps hope this will work for you.
i pasted the data in A1 to B7 as
Balloons 01/01/2013
Cards 01/01/2013
Balloons 01/01/2013
Balloons 02/01/2013
Cards 03/01/2013
Balloons 03/01/2013
Streamers 03/01/2013
then in G2 i pa
Dear Xls Sir,
Can you explain the below formula.
When we used Lookup formula and Rept .
Why you have mention in formula "Z" and 255 ?
Thanks in Advance .
Regards,
Prafull Jadhav.
On Thu, Apr 11, 2013 at 10:56 PM, Gum Nam wrote:
> HI,
> Thanks, I tried your formula it gave me an error N/A
>
Thanks a lot for the same.
On Thu, Apr 11, 2013 at 7:31 PM, P.VIJAYKUMAR wrote:
> Dear Praful,
>
> There is plenty of difference between Data Validation and a drop down box
> from the developer tab.
> The list box in the data validation or data validation in general is used
> for validating an
I think the output would containd three values Cards, Ballons, Streamers
and for this output below is the formula. Confirm it with CSE
*
=IFERROR(INDEX($A$1:$A$8,SMALL(IF(((VALUE($B$2:$B$8)>=VALUE($D$1))*ROW($A$2:$A$8))=0,"",((VALUE($B$2:$B$8)>=VALUE($D$1))*ROW($A$2:$A$8))),ROW($A$1:$A$8))),"")
*
Hi,
I was hopiong somebody could help me with a formula that would identify
anyoccurences that happen after a particular date but not before. I.e. I
havea column of values (say product orders) that occur accross dates.
Bearing in mind that more than one order can occur on a particular date (so
Hi Amit,
Thanks for helping. I am confused with your 3rd. step. Can you please
explain?
Thanks
On Wednesday, April 10, 2013 11:23:39 PM UTC-7, Amit Desai (MERU) wrote:
>
> Assuming you have each ID of 6 characters, What you can do is;
>
> 1) In B2, =Left(A2,3) – this will separate your fi
HI,
Thanks, I tried your formula it gave me an error N/A
On Wed, Apr 10, 2013 at 11:26 PM, xlstime wrote:
> Hi Shaukheen,
>
> Please try below formula
> For text =INDEX(F5:F11,MATCH(REPT("z",255),F5:F11))
> For Number =LOOKUP(9.99E+22,F5:F11)
>
> .
>
> Enjo
Thank You very much for prompt response!
On Thu, Apr 11, 2013 at 10:22 PM, ashish koul wrote:
> =MID(A1,FIND(5,A1),6)
>
>
>
> On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA
> wrote:
>
>> Hi Team,
>>
>> I need a formula to find anything starting from 5 in a cell and to take 6
>> digit right of
=MID(A1,FIND(5,A1),6)
On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> I need a formula to find anything starting from 5 in a cell and to take 6
> digit right of the cell starting from 5 as below.
>
> Eg.
>
> DataDesired Result
> ABC 500012 XYZ
Hi Team,
I need a formula to find anything starting from 5 in a cell and to take 6
digit right of the cell starting from 5 as below.
Eg.
DataDesired Result
ABC 500012 XYZ 500012
XYZ500134XYZ 500134
Regards,
Kaushik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
SIR,
i am vinod recently i got MOS certificate now im looking for join in job
kindly send me MOS or EXCEL VBA related RESUMES to my mail id
gvk...@gmail.com it will help me for jobs.
VINOD
--
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) ! Joi
HI Lalit,
Thanks for helping me. Yes there is always 2 or 3 alphabets in the
beginning, followed by numbers and sometimes with decimals.
I hope I explained it well.
On Wed, Apr 10, 2013 at 8:40 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> Is there any pattern of ID's like starti
Dear Praful,
There is plenty of difference between Data Validation and a drop down box
from the developer tab.
The list box in the data validation or data validation in general is used
for validating an entry which adheres to specified condition or not.For
example when a cell or range of cells a
Dear LK,
Please try it..
=GET.CELL(63,INDIRECT("RC[-1]",))
On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi wrote:
> Dear All
>
> I need formula for this particular query so please provide me any any
> formula instead of macro
>
>
>
>
> Dear All
>
>
> In the given sheet i want sum on the basis of
There is an add-in for Excel 2007, 2010, and 2013 called xCELLcolor that
provides sum by background color, count by background color, sum by font
color, and count by font color formulas without having to use VBA/macros.
But that has to be installed on every system.
You can check it here.
http://d
Brother,
There is any formula based on the conditional formating or sumif based in
which we can recognise about the colour so i want to know that brother
-- Forwarded message --
From: Prince
Date: Thu, Apr 11, 2013 at 5:13 PM
Subject: $$Excel-Macros$$ Re: Sum on the basis of c
Hi Modi,
We cant recognize colours in formula so only solution for the same is macro
regards
Prince
On Thursday, April 11, 2013 3:20:36 PM UTC+5:30, L.K.Modi wrote:
>
> Dear All
>
>
> In the given sheet i want sum on the basis of colour , is there any
> formula to solve my problem
>
>
> regards
Thanx!! to all of you
it has solved my query completely.
Regards,
Deepak
On Wed, Apr 3, 2013 at 10:58 AM, prafull jadhav wrote:
> Dear Anil,
>
> Ok..thanks .
>
> Can you clear one things here ..is there any different between validation
> and drop down box is taken from developer menu
>
> Regar
Dear All
I need formula for this particular query so please provide me any any
formula instead of macro
Dear All
In the given sheet i want sum on the basis of colour , is there any formula
to solve my problem
regards
L.K.Modi
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w
Your requirement is not clear.
Do you want to open the files as per your choice or you also want to merge
their data? If its latter, do all files have data in same format? What did
you mean by tick boxes? There is no screenshot / sample file with your
query.
Please elaborate.
Regards,
On Thu,
>Hi,
> Can someone please help me out with the macro for below thing
> If I saved the different excel file in one folder for ex : - 15 excel
> file with different name among them if i want to choose the 5 file as
> per my choice If I want to only 6 file which I required so that it can
> me
Very good
On Thu, Apr 11, 2013 at 4:00 PM, Abhishek Jain wrote:
> Attached.
>
>
> On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi wrote:
>
>> Dear All
>>
>>
>> In the given sheet i want sum on the basis of colour , is there any
>> formula to solve my problem
>>
>>
>> regards
>> L.K.Modi
>>
>> -
Attached.
On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi wrote:
> Dear All
>
>
> In the given sheet i want sum on the basis of colour , is there any
> formula to solve my problem
>
>
> regards
> L.K.Modi
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,D
Dear All
In the given sheet i want sum on the basis of colour , is there any formula
to solve my problem
regards
L.K.Modi
--
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/d
Hi,
You can use below formulas:
*=VLOOKUP($A1,$F$1:$G$17,2,0)
*
*=INDEX($G$1:$G$17,MATCH($A1,$F$1:$F$17,0))
*
*=OFFSET($G1,0,0)*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consi
Dear
=VLOOKUP(A1,$E$1:$F$17,2,0)
get the result
Alpesh
On Wed, Apr 10, 2013 at 10:04 AM, अनिल नारायण गवली
wrote:
> Dear alanthomas,
>
> Put approximate match or exact match then the result will appear.
>
> =vlookup(value,range,columnno,true,false) or
> vlookup(value,range,columnno,1,0)
>
>
>
Missed to attach sample file in trail mail.
On Thu, Apr 11, 2013 at 12:48 PM, C.G.Kumar wrote:
> Thanks for trying but still the solution is not useful to me.
>
> Let me explain correctly; Auto filter based on condition.
>
> Data is available in range (say A6:I6) and i need filter based on
> con
Thanks for trying but still the solution is not useful to me.
Let me explain correctly; Auto filter based on condition.
Data is available in range (say A6:I6) and i need filter based on condition
.Number of condition may vary from time to time but conditions need to be
entered manually as require
Refer to link http://lotusnoteconnection.blogspot.in/ for lotus note script
On Wed, Apr 10, 2013 at 2:04 PM, अनिल नारायण गवली
wrote:
> Yes, U can do it by notes.notessession.
>
> Warm Regards,
> Gawli Anil
>
> On Wed, Apr 10, 2013 at 1:42 PM, C.G.Kumar wrote:
>
>> Can we do the same thing using
30 matches
Mail list logo
