Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2021, 01:07 PM
allex011 allex011 is offline Help with formula Windows 7 32bit Help with formula Office 2007
Advanced Beginner
Help with formula
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default Help with formula

I have a excel file that has several types of documents for which it should assign numbers, if it is "other" type of document to give a new number, while if document is bill to assign an old number.


Thanks in advanced
Attached Files
File Type: xlsx Sample.xlsx (10.2 KB, 9 views)
Reply With Quote
  #2  
Old 11-27-2021, 12:59 AM
Marcia's Avatar
Marcia Marcia is offline Help with formula Windows 10 Help with formula Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Alexx, so in the right tables, the new documents are manually inputted and their numbers?
Reply With Quote
  #3  
Old 11-27-2021, 01:15 AM
allex011 allex011 is offline Help with formula Windows 7 32bit Help with formula Office 2007
Advanced Beginner
Help with formula
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default

Right down table fills in on its own with data, date, type document (other) from big table and then generate incoming number (in right down table) and then ad to big table.
If type document is not "other", look in right up table and ad incoming number to big table.
Reply With Quote
  #4  
Old 12-03-2021, 11:41 PM
Purfleet Purfleet is offline Help with formula Windows 10 Help with formula Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

How about this? not sure it is very efficent, but it seems to work on this small data set
Attached Files
File Type: xlsx Copy of Sample_AR12.xlsx (11.8 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Copy Row 2 Row But Next Column In Formula From Another Tab TimG Excel 3 04-16-2018 09:20 PM
Help with Formula Barbiro Excel 5 06-24-2017 10:26 AM
Help with formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Help with formula Formula Excel Excel 1 08-14-2014 05:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:47 AM.


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