![]() |
|
#1
|
|||
|
|||
![]()
Hello I want from lotto draws (for example 100) create a formula ( or another way )which can find 4,5,6,7 … numbers that appears in every draw
For example there are 3 draws , 1 draw =123 2 draw =145 3 draw= 456 the formula must gives these output =145 How can I do it ? Im beggineer may someone writes the formula if it is easy Or give me councils ? Thanks ![]() ![]() Last edited by macropod; 01-06-2012 at 10:50 PM. Reason: Changed from all-caps to Sentence case |
#2
|
||||
|
||||
![]()
Hi and welcome to the board.
Could you please add a small ample sheet with your data layout and expected result? Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
hello thanks for your post .i send a sheet.
![]() |
#4
|
|||
|
|||
![]()
I still don't see an example pointed out on your sheet of what you're trying to automate.
I was thinking initially a COUNTIF() formula to tell you how many times the number 4 was drawn? =COUNTIF(D:H, 4) Perhaps a smaller sheet with less data where you could easily write up your desired results manually so we see what you're after more clearly?? |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
![]() |
slayda | Word | 3 | 09-14-2011 02:16 PM |
Powerpoint: adding data to trend lines w/o data labels | HaiLe | PowerPoint | 0 | 04-11-2011 09:21 AM |
![]() |
Jaffa | Excel | 1 | 10-23-2010 02:39 PM |
![]() |
Bobosmite | Word | 6 | 05-27-2010 08:09 PM |