Given a Table: 100 Rows , in each row 10 cells, in each cell integer
1 digit (0 - 9)
Need to compare each row to the other rows, giving mark (0-10) to the
row equal the maximum cells found overlapping with one of the row in
the table.
Thanks.
--
--
Dear Dave,
Thank you very much.
Regards,
Mohamed.
On Sat, Jul 24, 2010 at 8:11 AM, Dave Bonallack
wrote:
> Hi Mohamed,
> Have a look at the attached to see if it does what you need.
> Regards - Dave.
>
> --
> Date: Fri, 23 Jul 2010 23:15:50 +0400
> Subject: $$Excel-
Hi Mohamed,
Have a look at the attached to see if it does what you need.
Regards - Dave.
Date: Fri, 23 Jul 2010 23:15:50 +0400
Subject: $$Excel-Macros$$ need date functin
From: idhrees...@gmail.com
To: excel-macros@googlegroups.com
Hi team,
I'm using excell sheet in that i have two column
Thanks for the encouragement :)
Best Regards,
DILIPandey
On 7/24/10, Rahul Gandhi. wrote:
> Great Job Done Dilip...
>
> Regards,
>
> Rahul Gandhi
>
> On Jul 23, 6:42 pm, Dilip Pandey wrote:
>> You are always welcome..!!
>>
>> And formula logic is explained below:-
>> =OFFSET($D$1,SMALL(IF($B$2:
Thanks Rahul,
No doubt, "concatenate" and "&" will do the task but for that we need
to have a column on both d locations n we also need to check if this
is feasible.
But anyways both the ways are ok n there are other ways as well :)
thx,
DILIPandey
On 7/24/10, Rahul Gandhi. wrote:
> I Think in
Hi all,
I have attached a spreadsheet that shows list data to the left but then under
the Item numbers is the amount of reach combo in the list and item number. I
would like the data in list format instead of pivot table style format. The
result I'd like to see is included in the worksbook wi
I am looking to clean up a file that gets sent to me weekly see
"example file.xlsx" on file page. The file may look like the first tab
the 1st week it is sent to me and like the second tab the 2nd week it
is sent to me but I need it to look like the 3rd tab all the time for
import into database. Ca
Hi team,
I'm using excell sheet in that i have two columns date and status. from
there i check the date column whether its current date its status i need
"OK" otherewise its "Expired". i need a simple formula to solve this one.
Anyone can help me. here i attach sample excell sheet.
--
Thanks & R
I Think in particular this scenerio we have one more function of
"Concatenate" or "&".
that also helps us to do the same, at the other hand this formula is
also very suitable for so many conditions..
Thanks again sir.
On Jul 23, 6:33 pm, Dilip Pandey wrote:
> Hi Hari,
>
> I have achieved the
Great Job Done Dilip...
Regards,
Rahul Gandhi
On Jul 23, 6:42 pm, Dilip Pandey wrote:
> You are always welcome..!!
>
> And formula logic is explained below:-
> =OFFSET($D$1,SMALL(IF($B$2:$B$51=$G$7,ROW($B$2:$B$51),""),ROW(1:1))-1,0)
>
> So, I am offsetting the heading D1 in the array which cont
Hi Kumar
find required info on below mention link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=380
On Fri, Jul 23, 2010 at 11:51 AM, Kumar Punnam
wrote:
> Dear Friends,
>
>
> I am having important information in Sheet2 which wa named as "Fuel Item"
> along with Sheet1 "Fuel Summary", i wo
Hi Vijay
if you want to convert a figure in to words for other files then either you
have to copy vb code in other files or you can download addin from below
mention link which convert a figure in to words
http://www.simpletaxindia.org/2010/01/convert-figure-to-word-excel-excel.html
On Fri, Jul
First of all, even using %% it would be possible for
any user to "extrapolate" the hours worked for others!
I mean, if I know MY hours were 8 on a given day,
and it shows 33.3%, then I know that anyone ELSE
that shows 33.3% ALSO worked 8 hours!
Now.. if what you wanted to do was to have separate
All, thanks for all the reponses. That's what I was thinking that it
was not possible without having 'base' numbers.
Don't want to share data of hours worked between individuals so it
possible to lockdown worksheets by individuals, with password per
worksheet?
On Jul 23, 7:08 am, Dave Bonallack
hello sir, the idea was to use all this thing without using password, with
help of macro
On Fri, Jul 23, 2010 at 12:44 PM, Dave Bonallack
wrote:
> I thought the idea was to disallow editing.
> Anyway, at the moment, you only need to select Protection from the tools
> menu and unprotect t
Hi Leandro,
Sorry Leandro,I was little bit busy,so i m not able to deliver it
immediately.
Please find the following code for Import text file.
Sub ImportTextFile()
Dim Fname As Object
Fname = Globals.ThisWorkbook.Application.GetOpenFilename("Text Files
(*.txt),*.txt", , "Select Text Data File
Yeah, I just got it from the macro recorder. I didn't play with it.
Dave.
> Date: Fri, 23 Jul 2010 04:44:33 -0700
> Subject: Re: $$Excel-Macros$$ Inserting a Vertical Line
> From: steve.slec...@gmail.com
> To: excel-macros@googlegroups.com
>
> P.S. - Here's the logic I figured out by trial and
You are always welcome..!!
And formula logic is explained below:-
=OFFSET($D$1,SMALL(IF($B$2:$B$51=$G$7,ROW($B$2:$B$51),""),ROW(1:1))-1,0)
So, I am offsetting the heading D1 in the array which contains the data rows
related with Emp ID "10779" and here I am considering the min(smallest) row
so th
Hi,
Have a look at the attached.
Regards - Dave.
> Date: Fri, 23 Jul 2010 14:51:00 +0530
> Subject: Re: $$Excel-Macros$$ Auto Calculate Number to Percent
> From: sandymau...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave,
>
> Please send the VBA solution for me. I can't get a logi
P.S. - Here's the logic I figured out by trial and error from your
code Dave:
(L/R End Point, U/D End Point, L/R Start Point, U/D Start Point)
where L/R (Left/Right) is the horizontal axis and U/D (Up/Down) is the
vertical axis.
Not sure why there was a '#' sign in the recorder code but it was n
Awesome! That did the trick Dave. Thanks!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linke
Hi Dave,
Please send the VBA solution for me. I can't get a logic which can
solve this problem without saving "Hour Worked" values. The problem
part with me is when a new value added to data it will not show the
correct percentage value. The cause I already mentioned in previous
reply.
If MNM nee
Hi Hari,
Do you want to hide the blank rows, OR
Do you want to remove the grid lines of the blank rows, OR
Do you want both i.e., remove the grid lines of the blank rows and then hide
them.
I think if you select the "Non-blanks" via Auto-filter at the last rows, you
can get the desired results, e
HLC
Hai Friends,
Please open the attached Excel file. I need your help.
I have to total 3 columns at the end of the report. I can do it by
selecting a particular ROW and insert Total function commands (=sum(E5:E35).
But if I do this, the Grid lines will appear upto the last Row, where,
total f
Thanks, Sandeep. I really appreciate it.
Edgar
On Wed, Jul 21, 2010 at 10:15 PM, Sandeep Kumar Maurya <
sandymau...@gmail.com> wrote:
> Hi Edgar,
>
> Function you are applying is correct. So please attached your file so
> that problem can be solved.
>
> Thanks & Regards
> Sandeep
>
> On Thu, Jul
I thought the idea was to disallow editing.
Anyway, at the moment, you only need to select Protection from the tools menu
and unprotect the sheet. The sheet will reprotect after any change.
As for multiple selections, why do you need it?
Regards - Dave.
Date: Thu, 22 Jul 2010 20:09:26 +053
26 matches
Mail list logo
