Hello Neeraj
CTRL+1 on the value column --> Custom --> select type *0.00*
cheers
On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan wrote:
>
> Dear Experts,
>
> kindly find the attached sheet.
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexc
Hello,
The configuration is oke , video card should be separated not integrated
and as for company that you should choose , i rather opt for Asus ,Toshiba.
On Saturday, October 20, 2012 3:03:22 PM UTC+3, Vabz wrote:
>
> Hi,
>
> All I want to buy good laptop for my personal use, pl experts s
Thank you for sharing those guides.
Appreciate .
On Saturday, October 13, 2012 7:33:27 PM UTC+3, prince sethi wrote:
>
>
>
> --
>
>
> Regards
>
> [image: Description: cid:image003.png@01CBFC21.609970A0]
>
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discus
Hello,
Maybe this UDF would be useful for you.
Function RemoveSpChars(s As String) As String
Dim re As Object
'List all allowed characters, but start with the negation "^"
Const sPat As String = "[^A-Z0-9 ]"
'List all characters to be removed, "-" must
' be listed first or last
'Const sPat As S
up.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Excel Challange(core).xls
Description: MS-Excel spreadsheet
Office 2013 is operating on Windows 7 (x86 , 64bit ) and Windows 8 *ONLY*.
On Tuesday, July 31, 2012 1:58:12 PM UTC+3, Annu wrote:
>
> Is it can run on winxp sp3 or not?
> Regards,
> Gawli Anil
>
> On Tue, Jul 31, 2012 at 4:15 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Joshep,
>>
>> Please see scre
Hello , Anjali
A very nice technique is you can customize your toolbar by going to Excel
Option -> Customize -> select All Commands add what you want to Quick
Access Toolbar.
After that you can easily access them by pressing ALT + number showed below
picture
Example in the file attached.
Ho
Hello ,
In case you have to files .xls and .xlsx you have to make formula with
Insert Function ( ALT + I + F ).
instead of write =vlookup or =lookup
give it a try.
On Tuesday, July 10, 2012 12:23:47 PM UTC+3, Bhaity wrote:
>
> Hi Experts,
>
> i am getting error in vlookups in finding the
Hello Khan,
Please check the file attached , hope it helps.
On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote:
>
> Hello,
>
> I need IF formula in attached sheet. IF Column C>0, Then Pre-Ops otherwise
> Construction, IF Column F>0, then Commissioning otherwise Pre-Ops & IF
> Col
Thank you Hilary for sharing those templates with us , but would be very
useful ,not just looking how it looks but to be customizable as well.
What is the point sharing with us protected files , not that i cannot find
a password breaker but like i sayd would be more useful if protection is
of
may <
>>>> mangesh.da...@gmail.com> wrote:
>>>>
>>>>> Thanks Noorain for sharing such nice examples..!!!
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI <
>>>>> noorain.ans.
Thank you for the advertisement , but that ain't what you are saying...
Less QQ more PewPew
On Wednesday, June 20, 2012 4:26:17 AM UTC+3, vijay wrote:
> Hello Pankaj,
>
> To get more financial Dashboards and templates visit www.exinfm.com.
>
>
>
> Regards,
> P.VIJAY KUMAR
>
On Wed
Hello Noorain,
That ain't a tutorial , but thanks for sharing
On Monday, June 18, 2012 8:47:45 PM UTC+3, NOORAIN ANSARI wrote:
> Dear Pankaj,
>
> Please find attached Dashboard Tutorials,
> Hope it will help to you.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www
hey Lokesh,
Try CTRL+ ~ (button next to 1)
On Thursday, May 31, 2012 3:58:53 PM UTC+3, lokesh wrote:
> Hi Expects,
>
>
>
> Here it is the screen shot for the formula. And please do the needful.
>
>
>
>
>
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, a
Hello Tarun,
Don't know if i understood , but if you have problems scrolling the
spreasheet , make sure that your Scroll Lock @ keyboard is not on , and 2nd
thing
freeze panes also are no set on.
Hope it helps!
On Wednesday, May 30, 2012 1:19:41 PM UTC+3, TARUN wrote:
> Sir ,
>
>
Hello Ashish,
I had installed 2003/2007 excel versions and i haven't meet any crashes ,
now i have excel 2007 ver. and access 2003 ver.
to have both version installed on your machine , you need to change folder
destination.
On Tuesday, May 29, 2012 5:16:40 PM UTC+3, Ashish wrote:
>
Hello Siraj,
Please give more information , attach an example.
On Thursday, May 17, 2012 8:47:26 AM UTC+3, Siraj Momin (BTG) wrote:
> Dear Excel Group Friends
>
>
>
> Is there any way that certain rows of a sheet is repeated at the bottom of
> each page……
>
>
>
>
>
>
>
> Siraj
>
>
dear Noorani,
do you have material for intermediate level user in which macro and
other material related to advance is not included.
plz send me.
On Thursday, May 17, 2012 7:56:40 AM UTC+3, TARUN wrote:
>
> dear Noorani,
>
> do you have material for intermediate level user in which macro
Hello Smitha,
Instead of IF , if you are using 2007 version you can use SUMIFS , if you
are on 2003 Sumproduct can help you.
On Wednesday, May 16, 2012 2:11:28 PM UTC+3, Smitha S R wrote:
> How can we add so many conditions in IF function?
>
--
FORUM RULES (986+ members already BANNED f
Hello,
PFA!
On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote:
> Dear All,
>
> I have a list of industry in one column and in corresponding column
> the rates as per industry are given. I want to create a formula
> whereby when i selected a specific industry from the dro
. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Help(Core Solved).xls
Description: MS-Excel spreadsheet
More infos , less gibberish please.
On Friday, May 4, 2012 11:30:18 AM UTC+3, ankit wrote:
> Dear all,
>
> I have some data in one sheet and I have to generate report which format
> is also on second sheet. How can we generate it.
>
> Thanks & Regards,
> Ankit
>
--
FORUM RULES (986+ members
Hello Karthik,
You can use text to columns function to get your desired format.
Check attached file.
On Sunday, April 29, 2012 11:08:10 AM UTC+3, karthik n wrote:
>
> Hi friends,
>
> Find the attachment of company address,how to spreat'up the colomn wise
> data
>
> Sample data is attache
Hello Ravin,
Please check the file attached .
To open Data Validation form , ALT+ D + L
If you have any queries , let me know.
On Thursday, April 26, 2012 11:49:56 PM UTC+3, ravin wrote:
> Dear All,
>
>
>
> I am making large data sheet of company name list.
>
> My concern is when
Hello Vijay.
PFA.
On Tuesday, April 24, 2012 8:31:29 AM UTC+3, Vijay Mane wrote:
>
>
> Hi Experts,
>
> Please refer file for more information
>
> I want to calculate top performer agent according to achieved target and
> quality
> If there are multiple agent with same achieved target and qua
Hello Rd
In the Review tab , Protect Workbook/Structure , create a password , after
in the same tab go on Protect Sheet create a password and it is done.
On Tuesday, April 24, 2012 12:03:51 PM UTC+3, Rd wrote:
>
> I ant to block cell editing or editing a sheet without using a password
> in
Hello,
use Call "Your Macro Name" without ""
On Thursday, April 5, 2012 9:56:14 PM UTC+3, Matt wrote:
>
> Hello, I'm trying to call a public function in one module from another Sub
> procedure in another module and it won't call the the function. I get an
> error that says.."sub function not d
CTRL+1 --->Custom format , choose the one you need.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not
n't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
NAMES+LIST(core-solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Hello,
delete some raw date and shoud be fine :)
On Monday, March 26, 2012 2:10:18 PM UTC+3, Bheema Shankar wrote:
>
> Dear Owner of the Community
>
> Recently posting query by an attachment was failed due to size of the
> file. The returned comments by the server is that the blog is not
> ac
k. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Due+Amount(CoRe Solved).xlsx
Descrip
Hello Pandey,
If you are using excel 2007 or later , you can use Clipboard CTRL+C
pressed twice.
On Monday, March 19, 2012 1:53:08 PM UTC+2, Divaker Pandey wrote:
>
> Hi Expert,
>
> Can anyone give me a hint to findout last and second last copied item.
>
>
> Divaker
>
--
FORUM RULES (986+
Hello, new around here ..
here is something that might help you...
luni, 12 martie 2012, 17:22:04 UTC+2, hilary lomotey a scris:
>
> Hi Experts
>
> i am trying to use the logical formula ie < or > operator to have an
> outcome such that if the figure in say cell A is greater than that of cel
33 matches
Mail list logo