Assuming you have each ID of 6 characters, What you can do is;
1) In B2, =Left(A2,3) - this will separate your first 3 characters which
are alphabetic. Drag the formula down
2) In C2, =right(A2,3) - this will separate your last 3 characters which
are numeric. Drag the formula down.
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)
.
Enjoy
Team XLS
On Thu, Apr 11, 2013 at 3:51 AM, shaukh...@gmail.com wrote:
I have a sheet with lot IDs in Col A
AAA100
The macro provided does not serve the purpose. It does not filter data
based on condition provided in row 1:2.
The data needs to filtered on the same place and not on different location.
Output given in sample sheet was only for checking the results .
I hope you can modify the results .:)
On
Dear All,
Can any any plz share with me some good study material or any link on SAS
and
SPSS or any institute in mumbai.
Wanted to learn IT asap. Plz feel free to call and advice me 09967118180.
Thanks in Advance. Cheers :)
--
Thanks Regards,
Amol Shrivastava
+91 99671 18180
--
Are you
Probably, one of the library is missing or not selected in excel installed
in your PC or laptop.
Add all the libraries. You can check the libraries by checking the box in
VBA editor..
below is the screen shot to help you.
On Wed, Apr 10, 2013 at 2:29 PM, Hari Nair hari.shrin...@gmail.com
Refer to link http://lotusnoteconnection.blogspot.in/ for lotus note script
On Wed, Apr 10, 2013 at 2:04 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Yes, U can do it by notes.notessession.
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 1:42 PM, C.G.Kumar
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
Missed to attach sample file in trail mail.
On Thu, Apr 11, 2013 at 12:48 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
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
Dear
=VLOOKUP(A1,$E$1:$F$17,2,0)
get the result
Alpesh
On Wed, Apr 10, 2013 at 10:04 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear alanthomas,
Put approximate match or exact match then the result will appear.
=vlookup(value,range,columnno,true,false) or
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*
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 @
Attached.
On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi ca.mod...@gmail.com 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
Very good
On Thu, Apr 11, 2013 at 4:00 PM, Abhishek Jain abhishek@gmail.comwrote:
Attached.
On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi ca.mod...@gmail.com wrote:
Dear All
In the given sheet i want sum on the basis of colour , is there any
formula to solve my problem
regards
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
merge
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,
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
Thanx!! to all of you
it has solved my query completely.
Regards,
Deepak
On Wed, Apr 3, 2013 at 10:58 AM, prafull jadhav prafulltjad...@gmail.comwrote:
Dear Anil,
Ok..thanks .
Can you clear one things here ..is there any different between validation
and drop down box is taken from
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
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 prince141...@gmail.com
Date: Thu, Apr 11, 2013 at 5:13 PM
Subject: $$Excel-Macros$$
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.
Dear LK,
Please try it..
=GET.CELL(63,INDIRECT(RC[-1],))
On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi ca.mod...@gmail.com 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
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
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 starting
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) !
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))
=MID(A1,FIND(5,A1),6)
On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
Thank You very much for prompt response!
On Thu, Apr 11, 2013 at 10:22 PM, ashish koul koul.ash...@gmail.com wrote:
=MID(A1,FIND(5,A1),6)
On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA
savla.kaus...@gmail.comwrote:
Hi Team,
I need a formula to find anything starting from 5 in a cell
HI,
Thanks, I tried your formula it gave me an error N/A
On Wed, Apr 10, 2013 at 11:26 PM, xlstime xlst...@gmail.com 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)
.
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 first
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
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))),)
*
On
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 shaukh...@gmail.com wrote:
HI,
Thanks, I tried your formula it gave me
32 matches
Mail list logo