Hi via,
Please find the spreadsheet containing the scenario mentioned alongwith the
required solution.
Let me know if this works.
Best Regards,
DILIPandey
On Sat, Jan 8, 2011 at 10:27 PM, via135 via...@gmail.com wrote:
hi all..!
everyday i am entering value of a product of different
congratulations Manoj.. :)
Best Regards,
DILIPandey
On Mon, Jan 10, 2011 at 9:18 AM, Manoj kumar manoj.vishwakarma...@gmail.com
wrote:
Thanks :)
Regards,
Manoj Kumar
On Sat, Jan 8, 2011 at 2:58 PM, Maries talk2mar...@gmail.com wrote:
Congrats Mr.Manoj..
-- Forwarded
I have an Excel spreadsheet which compiles a summary report by linking
to many
spreadsheets, whose file names are computed according to the date,
e.g. If Cell A1
contains '[Data_2010_December]Inputs'! the link formula might be =
+INDIRECT(A1D$65)*1
That works fine provided that file
Hi Friends,
Want a formula that find the value as positive or pending as per horizontal
and vertical.
Thanx...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Anil,
Try this:
In Excel2007, go to the Developer tab.
In the Controls group (center section) select the Design Mode icon.
then, right-click on the button.
You should get a menu, but depending
on the type of button control,
the menu will be different.
If it is a Form Control, then there will
see the attachment see if it helps
On Mon, Jan 10, 2011 at 4:29 PM, lucky singh lucky60...@gmail.com wrote:
Hi Friends,
Want a formula that find the value as positive or pending as per horizontal
and vertical.
Thanx...
--
Hi Lucky,
Attached spreadsheet is formulated as per your requirements.
Let us know if this helps. :)
Best Regards,
DILIPandey
On Mon, Jan 10, 2011 at 4:29 PM, lucky singh lucky60...@gmail.com wrote:
Hi Friends,
Want a formula that find the value as positive or pending as per horizontal
Hi Ayush,
Thank you these graphs look awesome! I love the bar chart particularly
as it demonstrates our progress over 16 weeks.
However, I am not sure the pie chart represents what I would like to
report. Perhaps I am not being clear so I will try to explain what I
want to see differently. I
Hi,
If you are using xl2007 or more, you can use the IFERROR function.
In your case, I think the syntax would go something like this:
=IFERROR(INDIRECT(A1D$65)*1,Linked Workbook not open!)
But I don't have XL2007 here to check it.
Hope this helps.
Regards - Dave.
Date: Mon, 10 Jan 2011
Is there a way to change a filtered view by changing the value of a cell
rather than clicking the drop-down arrow and scrolling to the data you want
to filter it to?
Or more specific, see attached for a formula to look up all instances of a
specific variable.
Thank you.
John
--
Hi Paul
Thanks for the reply
I followed your instructions.
When I right click 'Next fortnight' button and select 'Assign macro' -
It
goes to second line of the code - =ECHO(FALSE) in 'Macro1' Sheet
When I right click Re-Calculate' button and select 'Assign macro' - It
goes
to second line of the
I would use =VlookUp in the corresponding cells in WorkbookA. You can
find some good videos on Youtube.com if you are unfamiliar with lookup
tables
On Jan 10, 1:13 am, Tom tcli...@gmail.com wrote:
How can you use vba to help me do this?
WorkbookA has 3 columns with these respective headings:
check the attachement see if it helps
On Tue, Jan 11, 2011 at 12:44 AM, John A. Smith johnasmit...@gmail.comwrote:
Is there a way to change a filtered view by changing the value of a cell
rather than clicking the drop-down arrow and scrolling to the data you want
to filter it to?
Or more
13 matches
Mail list logo