Hi Premor,
Really thanks a lot , very much cleared and inspired by your mail.
On Thu, Jul 18, 2013 at 7:11 PM, De Premor d...@premor.net wrote:
Sorry for my late response, a have to take a rest for a while (^_^)
*=SUM(IFERROR((Sheet1!$A$3:$E$6=$A4)*(Sheet1!$B$3:$F$6),0))**
** *
The
Dear Experts,
I have an Excel file. which has huge amount of data. it has more
than 100 columns contain various formulas and values. And more than
8,000 data. sometime I open this file, data unable to show. It look
like nothing is there, like whole sheet is hidden. but when I move
cursor using
Dear Vikas,
Can you please explain. what is this or how it works.
Thanks
Ashish
On Thursday, July 18, 2013 10:48:02 PM UTC+5:30, vikas wrote:
Jvo gv Buchanan! R g chives PBS:;,?! Gyvfchvjbhjvijvonvpvpvppp0
On Jul 18, 2013 9:42 PM, Ashish Kumar kumar.a...@gmail.comjavascript:
wrote:
Dear
Hi
Also state operating system you are using along with PC configuration and
RAM.
Its likely possible that low configueration and RAM may cause it.
Thanks
On 19 Jul 2013 12:08, Waseem Saifi waseemsa...@gmail.com wrote:
Dear Experts,
I have an Excel file. which has huge amount of data. it
Dear CGMAURYA,
The file is attached along with this post.
All details are mentioned below and same is also mentioned in my first post
along with attached file.
Regards
Vijay Yadav
On Friday, 19 July 2013 11:18:16 UTC+5:30, CGMAURYA wrote:
Dear Vijay,
Where is attached excel file.
On
Dear Sir,
Operating System is Microsoft Windows 7,
Processor is Intel Pentium Dual Core with 2.6 Ghz speed.
RAM is 2 GB.
Hard disk is approx 500 GB.
Regards,
Waseem Saifi
On Fri, Jul 19, 2013 at 1:29 PM, vba v...@vabs.in wrote:
Hi
Also state operating system you are using along with PC
thanks for suggestion.can u explain
On Fri, Jul 19, 2013 at 2:38 PM, Pravin Gunjal isk1...@gmail.com wrote:
Pl use v-lookup.
-- Forwarded message --
From: excel lerner exceller...@gmail.com
Date: Fri, Jul 19, 2013 at 10:20 AM
Subject: $$Excel-Macros$$ formula required to
Dear All,
Attached is a sample data in which I have some month wise item total, I
need a formula which can calculate SUM of an item from the Month Jan-12 to
till the month which we are selecting in the column D1.
Appreciate if somebody can help me with formula.
Best Regards
Excel_Lover
--
I've encountered similar issues before.
It seems to be a graphical memory issue.
Usually, I have several applications open at once.
At some point, the memory on the graphics card is exhausted.
Even when you exit the other applications, sometimes the graphics memory isn't
released.
My PC was
Dear Team,
I know how to protect sheet. but not able to protect / lock particular cell
/ row and column in Excel. Can you pls help in attached excel sheet how to
do it.
Also pls tell me how to protect Formulas in Excel.
Rgds,
Prabhakar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
On Fri, Jul 19, 2013 at 5:05 PM, Excel_Lover idforex...@gmail.com wrote:
Dear All,
Attached is a sample data in which I have some month wise item total, I
need a formula which can calculate SUM of an item from the Month Jan-12 to
till the month which we are selecting in the column D1.
Dear Mr.Deepak,
Thanks for a quick reply, your formula works fine but it's not considering
the items (A,B,C,D etc), it should also be a criteria because its order may
vary.
Hope it needed a formula like SUMIF which provides SUM by multiple
criteria.
Thanks again..
On Fri, Jul 19, 2013 at 2:58
Here's my answer:
=SUM(INDIRECT(ADDRESS(ROW(),8) : ADDRESS(ROW(),MATCH($D$1,$H$1:$Z$1)+7)))
Here's my logic:
You want to use the =SUM() function to calculate the total
for the current row from column H1 through the column described in D1.
For Jun-12, the SUM() function would look like:
In your first message, you didn't mention that the value in column A may not
match the values in the row!
The solution I provide could be used.
simply use the MATCH() function to return the row number of the matching value
from column A and use that instead of the ROW() functions I used.
Paul
Dear Mr.Paul,
I am sorry I didn't mentioned it in first e-mail.
I like your posts in this groups because you are the only one who posts
solutions with enough explanation.
I will try the formula with suggested changes and will get back to you with
the feedback.
Thanks for your time and help.
Yeah,
I modified it and worked perfectly.
Here is how's it now.
=SUM(INDIRECT(ADDRESS(MATCH(A2,$G$1:$G$14,0),8) :
ADDRESS(MATCH(A2,$G$1:$G$14,0),MATCH($D$1,$H$1:$Z$1)+7)))
Thanks again.
On Fri, Jul 19, 2013 at 3:29 PM, Excel_Lover idforex...@gmail.com wrote:
Dear Mr.Paul,
I am sorry
Excel does not support a lot of data. I think the ideal would be to store
the data on another worksheet, or access and process the data and make
queries on the worksheet page.
Em sexta-feira, 19 de julho de 2013 03h38min32s UTC-3, Waseem Saifi
escreveu:
Dear Experts,
I have an Excel
Hi Sandeep, has to do with what you need.
I need to know:: The database access is within the SQL server?
tks. and rgs.
On Wednesday, July 17, 2013 11:48:43 AM UTC-3, Sandeep Kumar Baranwal wrote:
Hi
Kindly note that sql.request is functional in MS Excel 2007 but not in MS
Excel 2010.
Respected Prabhakar,
First select all the sheet and go to format tab and go to the protection
tab and uncheck the locked and hidden chechmarks.Then Select the Cells,Rows
or Columns which you want to lock,the go to the format tab and then the
protection tab in the dialog box then check the locked
Not clear what you are trying to do but if your master sheet has different
names and you are trying to sum for your report sheet try the following:
=SUMIF(MASTER!$B$5:$B$35,Raman Choudary,MASTER!C5:C35)
That goes into B9 of your report sheet. You can then copy across. If B10 is
a different
Dear Prabakar,
Follow the bellow mentioned steps :-
- Select whole sheet by CTRL+A
- Press CTRl+1 for open Format Cell
- Go to Protect Tab and uncheck the lock and hidden checkbox.
Then After,
- Select the cell, column or row which you want to lock
- Go to Format Cell
-
Dear Team,
Kindly suggest how to export a table from MS access.
Please find the below given screen shot of the macro which is created.
This macro gives output only 65000 rows.
Kindly Suggest asap..
[image: Inline image 1]
--
Vijay
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
eliminate the Ptrsafe then try. it is because of the excel version issue i
hope so.
On Friday, July 19, 2013, De Premor d...@premor.net wrote:
I dont know why, but in my laptop also Rajan that Declaration running
well without any problem
I get that formula from Rajan :D, maybe he know why
Thanks for the compliment.
Excel isn't a solution.. it is a tool kit.
Once you master one of the tools, you combine it with other tools to CREATE
a solution.
It takes a bit longer, but if I instead describe the thought processes involved
in the selection of the tools, then you are better
Hmm... I have to disagree.
I have an excel workbook that has 75 columns and 127,000 rows (and growing).
THEN, the workbook has 20 sheets that report this data in different formats,
and are used for queries against the data.
I consider THIS a lot of data.
however, compared to the 5 million
Hi Experts,
if anyone have template for Ramp Up plan which is used for staffing
forecast. pls share. if possible i need explanation for the terms which is
used in that file.
Thanks Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
It depends on the preference of each. I suggest an idea for improving the
performance of file since lighter and worked up data
Em sexta-feira, 19 de julho de 2013 03h38min32s UTC-3, Waseem Saifi
escreveu:
Dear Experts,
I have an Excel file. which has huge amount of data. it has more
Team.. Pls help
-- Forwarded message --
From: vijayKumar midearfam...@gmail.com
Date: Fri, Jul 19, 2013 at 7:20 PM
Subject: $$Excel-Macros$$ Export Table Created in Access(2007)
To: excel-macros@googlegroups.com
Dear Team,
Kindly suggest how to export a table from MS access.
The DoCmd.TransferSpreadsheet command, when activated with parameter
acSpreadsheetTypeExcel12, is able to export more than 65,536 rows.
So, create a macro (mcr_Exportation) and add the action ImportrExport
workbook ; Transfer Type: Export, type spreadsheet: Excel Workbook; Table
Name: YourQuery
Hi sir
In that file master sheet u entered 3rd july values.if i enter date 3rd
july at report sheet error showing at 2nd july values column? please help.
On Fri, Jul 19, 2013 at 3:26 PM, Pravin Gunjal isk1...@gmail.com wrote:
PFA.
Regards
Pravin Gunjal.
-- Forwarded message
Hi, try to use this spreadsheet to import from MS Access
http://goo.gl/YxPK6
Em sábado, 20 de julho de 2013 01h07min46s UTC-3, Chinnumanas escreveu:
Team.. Pls help
-- Forwarded message --
From: vijayKumar midear...@gmail.com javascript:
Date: Fri, Jul 19, 2013 at 7:20
31 matches
Mail list logo