send a sample sheet buddy
On Sun, May 9, 2010 at 12:07 AM, nino wrote:
> hi,
> does anyone have idea or solution to solve search over 2 columns range
> where both criteria needs to be met.
> e.g. if you have database with 3 columns. column A is account, column
> B is cost centar and column C is
You can concatenate Column A and Column B to get the unique value. Then do a
vlookup to get the exact value. Once performing this operation, you can
delete the concatenated column.
Hope this helps
Ta
Ravi
On Sun, May 9, 2010 at 12:04 PM, madhu nair wrote:
> send a sample sheet buddy
>
>
> On S
Please ignore earlier attached file. Please find the correct attachment.
Regards
- Forwarded by Dheeraj Bankoti/P&E/PLL on 05/09/2010 11:53 AM -
Dheeraj Bankoti/P&E/PLL
05/09/2010 08:17 AM
To
excel-macros@googlegroups.com
cc
Subject
Maximum Date
Dear All,
I have a spreadshe
Hello Andy,
I can use mail merge, but thats a manual process and I want to use different
format for for preparing letters which might go above 1000+ letter. Thge
problem using mail merge manually is that it again require formatting and
whicd adds up to more time in preparing letters.
Looking forw
Hi Dheeraj,
Why don't you sort the data with Date column in decending order...
Thanks
On Sun, May 9, 2010 at 12:53 AM, wrote:
>
> Please ignore earlier attached file. Please find the correct attachment.
>
>
>
>
> Regards
>
>
> - Forwarded by Dheeraj Bankoti/P&E/PLL on 05/09/2010 11:53 AM -
Hi Sundar,
You can do it with conditional formatting, I've attached a work to show you
how to do it, you just need to check the formula in conditional formatting
option.
Thanks
On Fri, May 7, 2010 at 5:02 AM, Sundarvelan N wrote:
> Hi Friends,
>
> Can any one help me to solve the below conditi
Already answered thisone let me know in case u missed d same.
Thx,
diLipandey
On 5/9/10, dheerajbank...@punjlloyd.com wrote:
> Dear All,
>
> I have a spreadsheet containing quite a lot of data, one of the columns is
> date & one of the data.
> My user would like to see the latest rows (as this ma
Guru,
I actually want to see both of those line items as percentages of
sales which is to say, take gross margin $ and divide it by sales.
Same for operating income.
Thanks!
--
--
Some important links for excel user
here you go
http://www.mediafire.com/download.php?nvt1ymtzjdy
thanks for your help!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2
Hello Friends,
I need to do this using VBA Coding. Please help me
Thanks,
Sundarvelan
On Sun, May 9, 2010 at 8:38 PM, deepak kumar wrote:
> Hi Sundar,
>
> You can do it with conditional formatting, I've attached a work to show you
> how to do it, you just need to check the formula in conditiona
10 matches
Mail list logo