Hi Pravin Gunjal
[?] Wowww its working... thanks a lot lot lot.. you saved my lots of lots
of time thanks again for your extraordinary tip.
On 10 April 2013 10:04, Pravin Gunjal wrote:
> Dear Prabhu
>
> By doing this only you will get From, To, Subject, Date & Time these field
> only and
Dear Prabhu
By doing this only you will get From, To, Subject, Date & Time these field
only and not e-mails data/communication in excel file. Pl try and confirm
to us.
- Pravin.
On Wed, Apr 10, 2013 at 7:09 AM, Prabhu Pinky wrote:
> i do not wants to paste the mails in excel. i want to copy th
Dear Norman,
Then share that sheet with us,
Warm Regards,
Gawli Anil
On Tue, Apr 9, 2013 at 5:50 PM, Norman West wrote:
> Hi Gawli,
>
> I protected the worksheets prior to looking at unprotecting certain user
> cells
>
> Norman West
>
>
> On Tuesday, April 9, 2013 11:12:18 AM UTC+1, अनिल नारा
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)
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 6:43 AM, Sam Mathai Chacko wrote:
> If you want to look for exact matches, you mu
i do not wants to paste the mails in excel. i want to copy the mail sent
time and mail subject only.
On 9 April 2013 16:40, Pravin Gunjal wrote:
> Directly you can go to the sent box and select all of them and hit Ctrl+C
> (copy) and then go to excel file and paste. Pl confirm.
>
>
> --
If you want to look for exact matches, you must use =VLOOKUP(Lookup_Value,
ArrayRangeToLookAt, Column_Index, Whether Approximate Match Or Not)
So try =VLOOKUP(A1,$E$1:$F$17,2,FALSE)
Regards
Sam Mathai Chacko
On Wed, Apr 10, 2013 at 5:51 AM, wrote:
> I am really confused about the behavior of
Thanks! This worked. However, I am not exactly sure why I got the weird
results without that.
--
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)
Hi,
After 2 in your formula plz add(, 0) for xl to recognize correct value.
--
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
I have changed the format of the columns and re-edited all the cells. This
got rid of the invalid results, but I still get many incorrect results on
the letters. I have looked up this topic on Google, but I have been able
to resolve this frustrating problem!
See attached, revised spreadsheet.
I am really confused about the behavior of my VLOOKUP functions in Column 2
of the attached spreadsheet. The function is simply
=VLOOKUP(A1,$E$1:$F$17,2). This is giving me wrong (undefined, or wrong
number) results for some of what I`m looking up. I have not found the
cause or a way around
Hi Gawli,
I protected the worksheets prior to looking at unprotecting certain user
cells
Norman West
On Tuesday, April 9, 2013 11:12:18 AM UTC+1, अनिल नारायण गवली wrote:
>
> Dear Norman,
>
>
> Before Protecting the entire sheet first goto review and click on allow
> users to edit the range
ear Rajan/Praful
Please find attched Sheet
Regards
Shrinivas
On Sat, Apr 6, 2013 at 3:51 PM, prafull jadhav wrote:
> Please share a example file with criteria
>
>
> On Sat, Apr 6, 2013 at 3:45 PM, Shrinivas Shevde
> wrote:
>
>>
>> Dear All
>> Can Anyone answer this
>>
>> Regards
>> Shrinivas
>>
=TEXT(D3,"-")
Drag down.
On Tue, Apr 9, 2013 at 4:35 PM, Pravin Gunjal wrote:
> Hi, I would like to convert the date in to the month & year format as
> follows/attached file.
>
> *Now* *Result* *DATE* *MONTH-YEAR* 7-Apr-12 April-2012 17-Apr-12
> April-2012 25-Apr-12 April-2012 2
Dear Norman,
Before Protecting the entire sheet first goto review and click on allow
users to edit the ranges and then protext the sheet.
Warm Regards,
Gawli Anil
On Tue, Apr 9, 2013 at 3:32 PM, Norman West wrote:
> I am reading "Excel 2007 for Dummies" in an endeavor to understand protect
>
I am reading "Excel 2007 for Dummies" in an endeavor to understand protect
and unprotect worksheets, and am more confused than ever over what one
would have thought an easy operation.
I have written a 4 page worksheet program and wish to protect all sheets
with the exception of some data entry
You can use code2 outlook addins. It does the same work with ease.
On Apr 9, 2013 12:01 PM, "Prabhu Pinky" wrote:
> Hi,
>
> For testing purpose, i have attached three mail herewith.
>
> This is not (.pst), i have copied sent items in my local folder.
>
>
> On 9 April 2013 11:56, Abhishek Jain wr
16 matches
Mail list logo