Hi Rakesh,
follow below link:
http://www.cpearson.com/excel/datedif.aspx
Regards
Anoop
On Fri, Dec 7, 2012 at 12:12 PM, Rakesh Kumar Sharma wrote:
> Dear Team,
>
> Can you help me how to calculate age ( in Year, month & day) in Excel
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-
Use the following one
=IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↕"))
On Fri, Dec 7, 2012 at 12:37 PM, amar takale wrote:
> Hi Annop,
>
> Good Solution.But If there are Constant number both cell then I want
> Neutral arrow,can it possible?
> Regards Amar
>
>
> On Wed, Dec 5, 2012 at 11:35 AM, Anoop K Sha
Hi,
if the date is (D111) - 12/20/1991, then
for no. year : =DATEDIF(D111,TODAY(),"y") = 20
for no. of month : =DATEDIF(D111,TODAY(),"m") = 251
for no. of days : =DATEDIF(D111,TODAY(),"d") = 7658
--- and if you want link 20 years, some month and some days then -
just chnage the text as -
fo
Hi Annop,
Good Solution.But If there are Constant number both cell then I want
Neutral arrow,can it possible?
Regards Amar
On Wed, Dec 5, 2012 at 11:35 AM, Anoop K Sharma wrote:
> Please find attached. I hope this can help you.
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Wed, Dec 5, 2012 at 12
Dear Team,
Can you help me how to calculate age ( in Year, month & day) in Excel
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titl
Hi,
=WEEKNUM(Future date,2)-WEEKNUM(today(),2)Weeknum gives number of week
you can change option (2) in formula as per your requirement, formula will
prompt you when you enter formula.
If this works otherwise tell us more detail
--- On Thu, 12/6/12, t vinay wrote:
From: t vinay
Subject: $$Ex
Thanks Anoop for helping & supporting me.
Regards,
C.G.Kumar
On Fri, Dec 7, 2012 at 9:40 AM, Anoop K Sharma wrote:
> Use the Ashish's formula for second case.
>
> Regards,
> Anoop
>
>
>
> On Thu, Dec 6, 2012 at 8:01 PM, ashish koul wrote:
>
>> try this
>>
>> =RIGHT(G4,LEN(G4)-FIND("~",SUBSTIT
It worked.
Thanks a lot.
On Thu, Dec 6, 2012 at 8:01 PM, ashish koul wrote:
> try this
>
> =RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4,"
> ","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","")
>
>
>
>
> On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar wrote:
>
>> Dear Anoop,
>>
>> Thanks.
>>
>> But the formula in
Hi ppl ,
Could u suggest some good vb and macros
material
On Dec 5, 2012 6:56 AM, "Dhaval Shah" wrote:
> Friends,
>
> pls go through the attached excel sheet
>
> in main sheet there is raw data of differenet date for different product
> now suppose product x trade for 5 days and 5 days close va
Hi Ahmed
If you want more help you will have to give us more information. It is not
helpful to just say "It did not work" You need to tell us just what you
want to happen when the date arrives, and you need to tell us what happened
when you made inserted the conditional formatting. It would be
Paul,
Wow! OK, let's see what we can do. Going with your most recent post first:
I tried running the ReadData first pass on the real output. I got an error:
"Run-time error '9': Subscript out of range". When I chose "debug," the
code that was highlighed was Ln 41, Col 1:
Sheets(Sht_Out).Range("
Need to create a summary sheet for the attached Excel doc.
Tab “Detailed” is the input tab and works fine.
Tab “Summary” should show the name from the A column in “Detailed” in any
cell that corresponds.
An example is showing Booth 1 is:
9am
10am
11am
12pm
Booth 1
Person6
On Thursday, December 6, 2012 9:17:50 AM UTC-6, Paul Schreiner wrote:
>
> Do you have the password?
>
> Is it asking for the password when you open the file? or when you try to
> select the range?
>
> (need to figure out if you are dealing with a protected file or sheet)
>
> if your pass
Ravinder Negi
Thanks for your support , But it does not work
Regards
Ahmed
On Thursday, December 6, 2012 1:50:24 PM UTC+3, Ahmed Ab wrote:
>
> Hi group ,
> Actually I am new here , And I am asking for you support
> Attached file has table for lease , I am searching for the possibility to
>
Hi,
PFA
On Fri, Dec 7, 2012 at 12:30 AM, JMac wrote:
> When I opened the file, the formulas don't work on my PC. WIll they not
> work in Excel 2003 ?
>
> Thanks
>
> On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote:
>
>> I've got a tracking sheet with 6 columns, each row being an en
When I opened the file, the formulas don't work on my PC. WIll they not
work in Excel 2003 ?
Thanks
On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote:
> I've got a tracking sheet with 6 columns, each row being an entry for
> equipment maintenance. Column C contains the serial number
If you're wanting to do it with simple functions..
What I'd do is add a column to the tracking sheet in which you
"concatenate" the serial number and activity.
Like: Cell G1: =C1&F1
and copy down.
Then, in the summary sheet, you can use:
=COUNTIF(Tracking!G:G,A1&B1)
Paul
-
Hi,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Thu, Dec 6, 2012 at 11:40 PM, JMac wrote:
> I've got a tracking sheet with 6 columns, each row being an entry for
> equipment maintenance. Column C contains the serial number of the
> equipment. On a separate
Hi All,
Is it possible to convert a Bitmap image (BMP) into a Excel file through
some Macro?
If it is possible then please send me the code.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of
I've got a tracking sheet with 6 columns, each row being an entry for
equipment maintenance. Column C contains the serial number of the
equipment. On a separate
sheet I have a summary, by serial number, that I want to calculate the
total number of times a particular entry is made on the tracking
There IS a way to get to the data in an excel file without opening it,
but I've not worked with that much.
Mainly because it's very convenient to simply have Excel disable display
updating.
In which case a macro can open hundreds of excel files and file/save them as
text files
in a relatively sho
Hi Expert
I want to convert many excel file in text format. So is this possible
to convert file without open a file or save as options. becouse i have
to consolidated many excel file in one excel so is this any suggestion
so please help
Thanks
Manoj
--
Join official Facebook page of this forum
Paul,
I'm very excited to find someone who thinks this will be fun! Once I know
more, I'm sure I'll think it's fun, too. :) I'm currently training other
staff members, but I will answer your questions as soon as possible later
today. I believe we do have the option of exporting as a text file.
Hi Sharath,
Can you pls provide ur workbook so that we can give you exact solution.
regards
prince
On Thursday, December 6, 2012 7:36:09 PM UTC+5:30, sharath chandra wrote:
>
> Hello,
>
> I have a set of 51 unique names.
>
> I want to extract rows that contain any one of the 51 names.
>
> Ple
Hi vinay,
Use this formula it will give you no of weeks between two dates:
let suppose : A1 contain Todays Date and C1 contain futures date then:
in A4:* = trunc((C1-A1)/7)*
*
*
*
*
*Regards*
*Prince*
*
*
On Thursday, December 6, 2012 8:48:34 PM UTC+5:30, t vinay wrote:
>
> Hi Team,
>
> can
Yes that Ȋ̝̊̅§ what I did.
The effect of that being 3 different macros
One to create a new sheet and name the sheet by the name item
Second to copy data from a particular sheet and paste it in the sheet created
above
The last one Ȋ̝̊̅§ to copy the format in that particular sheet and paste it i
Hi Hilary,
Your first query solution is:
Ws1.range("a1:ak132").copy
Ws2.range("a1:ak132").pastespecial xlall
application.cutcopymode=false
for Query 2: do you want set ws2 name should be strName ?
regards
prince
On Thursday, December 6, 2012 8:52:37 PM UTC+5:30, hilary lomotey wrote:
>
> U
http://www.exceltip.com/st/Calculating_Number_of_Days,_Weeks,_Months_and_Years_between_Dates/915.html
On Thu, Dec 6, 2012 at 8:48 PM, t vinay wrote:
> Hi Team,
>
> can you please help me with a formula to calculate the number of weeks
> from today to a future date.
>
>
>
> --
> Regards,
>
> Vi
WEEKS is easy.
Keep in mind that Excel "dates" are simply numbers.
The number of days since 1/1/1900.
You can use =TODAY() to get today's date:
So today (12/6/2013) is: 41249
a future date, for say, 11/8/2014 is 41951
The difference is: 41951 - 41249 = 702
divide that by 7 to get the number of we
Becky,
This looks like FUN (I know, sick AND twisted!)
---
There's a few things I need to help you out.
First of all, do you recieve this data already in an Excel file?
or is it a "flat" text file?
If it's a "text" file, it would almost be easier to use VBA to read t
Used Macro recording to achieved ♍Ɣ purpose thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 13:16:02
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ A
Hi Team,
can you please help me with a formula to calculate the number of weeks from
today to a future date.
--
Regards,
Vinay. T
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, l
Do you have the password?
Is it asking for the password when you open the file? or when you try to
select the range?
(need to figure out if you are dealing with a protected file or sheet)
if your password is "easypwd" then:
If the workbook is password protected, you can use:
activeworkbook.un
Here's a test file based on some of the assumptions below.
It's in Excel 2010 format.
If you need Excel97/2003 let me know.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you
Dear Expert,
I'm keen to learn many things on excel but I don't have proper guide line like
assignment or example to work out.
Can you please provide if you have anything's. So that I can improve my excel
skill
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT
Hi experts
I have been able to amend the code to pick any new sheet name that Ȋ̝̊̅§
created.
What I kindly request Ȋ̝̊̅§ the format from the first sheet to the new sheet.
See ♍Ɣ new code below.
Sub copydata()
Dim ws1 as worksheet
Dim ws2 as worksheet
Dim strtname as string
strName = She
try this
=RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4,"
","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","")
On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar wrote:
> Dear Anoop,
>
> Thanks.
>
> But the formula in sector gives errorenous result when the last text are
> like "HYD/DXB/AMS/DXB/HYD"
>
>
> Sample at
try these links see if it helps
http://www.dailydoseofexcel.com/archives/2006/11/29/html-tables/
http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm
On Thu, Dec 6, 2012 at 5:46 PM, Rakesh Joshi wrote:
> how update value in text box in website which contain
LOTS of ways to do this.
Some are much better than others (faster, more efficient)
We need more to work with.
- Are the rows filled with sentences, or multiple columns of values?
- Will the name match the entire cell value, or a portion of a larger string?
- Do you wish a case sensitive match?
use advance search option
http://office.microsoft.com/en-001/excel-help/filter-by-using-advanced-criteria-HP005200178.aspx
On Thu, Dec 6, 2012 at 7:36 PM, sharath chandra <
sharath.c.sambr...@gmail.com> wrote:
> Hello,
>
> I have a set of 51 unique names.
>
> I want to extract rows that contain
I have a couple of questions for you:
1) How do you obtain the string?
If that's not important for this exercise (you'll supply the string), I can
use StrValue as the variable and your can set this value however you may.
2) I believe you're saying that you want the user to enter the number of
Hello,
I have a set of 51 unique names.
I want to extract rows that contain any one of the 51 names.
Please help.
Thank you,
Sharath
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
That's not really my question(s).
I can write a function that checks sheet3, then sheet2, then sheet1.
But that's not very efficient if tomorrow you have to check 4 sheets, then 5 on
the next day.
also, a function could work for 20-30 rows, but if you get into a larger
spreadsheet,
the recalcu
Pravin,
It looks like you're wanting to find the "last" occurence of a name.
looking in sheet3, then sheet2, then sheet1.
Will there ALWAYS be a TOTAL of 4 sheets?
Or will the be sheets added periodically?
Is this something you'd rather hit a button and have it refresh sheet 4?
or would you rath
Thanks again Prince for your help earlier on this. Additional request
The code below enables me to copy data from sheet one to sheet two. The problem
I have Ȋ̝̊̅§
One. It doesn't copy the format in sheetone to sheet two. Kindly help with the
code
Two. This other code "addsheets" that creates a
how update value in text box in website which contain in table like as
I am having the text box in table in interexplorer.
As I can fill it if they are not it table using doc methon.
Please help me as soon as poosible.
--
Join official Facebook page of this forum @
https://www.facebook.
*Hi,*
*
*
*I have attached a sample worksheet here for immediate reference.*
*There is a cumulative sheet no.4 in which I required the values based on
the condition given in file.*
*
*
*Kindly inform me any formula or vb code for the same.*
*
*
*Thanks *
*Pravin Gunjal*
--
Join official Facebook
Thanks prince but I get a debug error on the
Strtname =sheets(1).range("a1"& rows.count).end(xlup)
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prince
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 03:51:53
To:
Reply-To: excel-macros@goog
Hi Hilary,
Just Replace Sheets(1).Range("A1")line Bysheets(1).Range("A" &
Rows.Count).End(xlup)
Regards
Prince
On Thursday, December 6, 2012 5:05:10 PM UTC+5:30, hilary lomotey wrote:
>
> Hello experts
>
> The below code aids me to add a new sheet and named according to the text
Hello experts
The below code aids me to add a new sheet and named according to the text in
cell A1. What I request Ȋ̝̊̅§ to modify this code to always pick the last item
in the row. For instance row 1 has ABX and row A2 has BCD it shd pick BCD as
the sheet name if there Ȋ̝̊̅§ a text in say row
hi Ahmed,If you want this through conditional formatting then you can paste
this =INDIRECT("g"&ROW())=TODAY()+14" in conditional formatting formula thanks
--- On Thu, 12/6/12, Ahmed Ab wrote:
From: Ahmed Ab
Subject: $$Excel-Macros$$ Lease date alarm
To: excel-macros@googlegroups.com
Date: Th
Hi group ,
Actually I am new here , And I am asking for you support
Attached file has table for lease , I am searching for the possibility to
get alarm from excel before the due date by certain period (i.e one week
before , two weeks ,)
Thanks for all
--
Join official Facebook page of
Dear Anoop,
Thanks.
But the formula in sector gives errorenous result when the last text are
like "HYD/DXB/AMS/DXB/HYD"
Sample attached.
Can you advise.
On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma wrote:
> Hi CG,
>
> PFA.
>
> Regards,
> Anoop
>
>
> On Thu, Dec 6, 2012 at 12:5
Hi,
Another way to do this with lesser formulas
Regards,
Nishant
On Thu, Dec 6, 2012 at 3:36 PM, ravinder negi wrote:
> HERE IS THE SOLUTION
>
> --- On *Thu, 12/6/12, C.G.Kumar * wrote:
>
>
> From: C.G.Kumar
> Subject: $$Excel-Macros$$ Extracting Text from Cell
> To: excel-macros@googlegroups.
HERE IS THE SOLUTION
--- On Thu, 12/6/12, C.G.Kumar wrote:
From: C.G.Kumar
Subject: $$Excel-Macros$$ Extracting Text from Cell
To: excel-macros@googlegroups.com
Date: Thursday, December 6, 2012, 12:59 PM
Hi ,
I need to extract a relevant portion from Excel cell.
Attached example file.
Many
Hi CG,
PFA.
Regards,
Anoop
On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar wrote:
>
> Hi ,
>
>
> I need to extract a relevant portion from Excel cell.
>
> Attached example file.
>
>
> Many Regards,
>
> C.G.Kumar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com
56 matches
Mail list logo
