Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2023, 06:38 PM
lcggrp lcggrp is offline Unique data Windows 10 Unique data Office 2016
Novice
Unique data
 
Join Date: Oct 2023
Posts: 4
lcggrp is on a distinguished road
Default Unique data

Hello, Good Day!




I have a sample file attached where it as data of which week and reason. Somehow, I would like merge the reasons in unique like = Week 1: "Absent/Late/Undertime" then so on so fort with each week. I tried if formula with the unique and Vlookup function but it's not working.

I would highly appreciate the help.


Thank you.
Attached Files
File Type: xlsx Sample.xlsx (8.2 KB, 2 views)
Reply With Quote
  #2  
Old 11-15-2023, 01:21 AM
ArviLaanemets ArviLaanemets is offline Unique data Windows 8 Unique data Office 2016
Expert
 
Join Date: May 2017
Posts: 857
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Not sure what you really want, but attached is an example how to get what you asked

I used Defined Tables instead ordinary ones.

From your example it remained unclear, how you'd handle week numbers starting from 10th one! In my example, it will be "Week10". In case the week values in your table were markers only, and real entries for them will be something different, you have to make proper corrections to formulas. Btw., I'd use numbers in format "yyyyww" instead (1st week of this year would be 202301). This allows to have data from several years to be entered into your table without problems!

As i did write at start of this post, I can't see any gain you can get from this. In table on Sheet2, i'd have columns where weekly counts for every of reasons would be calculated instead.
Attached Files
File Type: xlsx WeekInfo.xlsx (13.4 KB, 3 views)
Reply With Quote
  #3  
Old 11-15-2023, 06:24 PM
p45cal's Avatar
p45cal p45cal is offline Unique data Windows 10 Unique data Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Two offers in the attached:
1. In Sheet1 cell E1, a formula (lambda).
Also derivation of the lambda formula in cell E7 This cell is not needed, only there for information. See Defined names.

2. In sheet Sheet1 PQ, a Power Query solution. Should the data in the source columns A & B change, the result table at cell D1 will need refreshing by right-clicking anywhere in that results table and choosing Refresh.
Attached Files
File Type: xlsx msOfficeForums51652Sample.xlsx (20.9 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unique data Unique data per record in mail merge chart aplarsen Word VBA 2 02-16-2018 04:01 PM
Pulling Unique Data from a Table A Certain Number of Times (Advanced) nath1235 Excel 3 09-14-2017 04:21 PM
Unique data Appending unique data from one worksheet to existing data on another worksheet EdStockton Excel 1 08-06-2014 11:00 PM
Excel list to Word with Page Break on new unique data jeverett1 Mail Merge 3 07-30-2014 11:59 AM
Unique data data roll up under unique identifier NewGirl Mail Merge 1 11-15-2012 04:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:01 PM.


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