Posts by Oeldere

Re: pivot, VBA

crosspost

http://www.mrexcel.com/forum/e…l-basic-applications.html

Re: Count only first occurrence of criteria

[FONT="Tahoma"]You'rewelcome. We appreciate the feedback!
[/FONT]

Re: Unique ID formula from reverse date of birth

These birthdates are the same.

[TABLE="width: 211"]

[tr]

[td]

22597MohammadAkooji

[/td]

[/tr]

[tr]

[td]

22597MohammedAkooji

[/td]

[/tr]

[/TABLE]

I think that will be a typo.

Since you don't have any birthdate duplicated you can add 01 to the reversed date.

To check if a birthdate is duplicate I used Column N => copy paste to the a new sheet.

After that remove duplicates => data => remove duplicate

After that a Conditional Format to check if the date is duplicated

See the attached file.

Re: Unique ID formula from reverse date of birth

So the same user (with diferant accounts) just get 1 List ID?

And if the date of birth accours multiply time (with another member) it has to be the suffix 02 and suffix 03 (for the third member)?

Re: Count only first occurrence of criteria

See the attached file.

Re: Prevent duplicate data in columns

NON VBA solution.

D2 shows the text wrong input if it match to the given conditions.

See the green cell in the attached file.

D2=iferror(if(match(A2&B2&C2,$I$4:$I$6,0),"wrong input",""),"")

Re: Top 10

Sheet 2: cel a1 =Large(Blad1!$A$1:$A$15,row()) and drag down

Re: Top 10

pivot table can do that job for you. Reading your question again I see you already have a Top 10 so you can refer to that range in Sheet 1 (if you stand in sheet 2).

Re: Pivot Table Filter Updates

maybe something like this?

Re: consolidating data points of interest

Use a filter an select on the interest identifier by the 1.

Re: Filtering out duplicate information accorss a Table

in E1 => a1&b1&c1&d1

and after that remove duplicates

Excel 2007 => data => remove duplicate

Re: Populate a cell based upon Name Range

Thanks for the reply.

Thanks for the compliment.

Glad I could help.:)

Re: Populate a cell based upon Name Range

See the attached file.

Do you have questions or comments, just ask or comment.

Re: Populate a cell based upon Name Range

Post the excel file and i show it you.

Re: Populate a cell based upon Name Range

Put all zip code in one column (e.g. A)

Put the district in the adjusting column (e.g B)

Then you can use VLookup to find the district.

Re: Populate a cell based upon Name Range

I find it hard to tell, how you can solve it, without seeing your data.

Re: Counting and suming number of visible rows

See the attached file, for an example of subtotal (no VBA code).

Re: Populate a cell based upon Name Range

If you define the zipcodes per district, you can use VLookup for that.

Probably you get better help with an excel file (without confidentional information).

Re: Tier Pricing Using Index and Match Functions

I don't get it.

It looks up:
1) (cust no, product type)
2) and qty.

And it takes only if cust no AND product type exact match.

What should be the answer in yoiur question?

Re: Tier Pricing Using Index and Match Functions

See the attached file (green cell)

I used Vlookup to find the value.