Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2012, 04:18 PM
GPENTEZ GPENTEZ is offline find data Windows Vista find data Office 2010 32bit
Novice
find data
 
Join Date: Jan 2012
Location: greece
Posts: 2
GPENTEZ is on a distinguished road
Wink find data

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
Reply With Quote
  #2  
Old 01-07-2012, 01:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline find data Windows XP find data Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote
  #3  
Old 01-07-2012, 01:55 AM
GPENTEZ GPENTEZ is offline find data Windows Vista find data Office 2010 32bit
Novice
find data
 
Join Date: Jan 2012
Location: greece
Posts: 2
GPENTEZ is on a distinguished road
Default

hello thanks for your post .i send a sheet.
Attached Files
File Type: xls extra5_2011 (2) (1) (1).xls (183.5 KB, 15 views)
Reply With Quote
  #4  
Old 01-07-2012, 03:41 PM
JBeaucaire JBeaucaire is offline find data Windows XP find data Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

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??
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
find data Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
find data Is there a way to use "find/replace" to find italics words? 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
find data How to write a macro to find a specified name in a list of data? Jaffa Excel 1 10-23-2010 02:39 PM
find data can Find/Replace NOT find something? Bobosmite Word 6 05-27-2010 08:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft