Formula not working correctly
when formulating a two page expression, the first page is not reading the second expression. I have given you the two formulas - I would hopefully like to have this sorted; if possible.
the first one should denote the year: In this case 2020
=IF(MONTH($A$5)<>MONTH($A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1)),"",$A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1))
The second shouldgive me the first day of the year:
=IF(MONTH($A$5)<>MONTH($A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1)),"",$A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1))
Question, is this even possible?
- browser: msedge.exe
- oS: Windows 10 x64 Home Edition (build: 19041)
- winPath: C:\WINDOWS\
- userDir: C:\Users\RevMi\AppData\Roaming\
- freeRam: 17114165248
- locale: ena
- programDir: C:\Program Files (x86)\Auslogics\BoostSpeed\
- disks:
- 0:
- n: C:\
- freeSize: 104322158592
- 1:
- n: D:\
- freeSize: 781601837056
- 2:
- n: E:\
- freeSize: 122639958016
- 3:
- n: F:\
- freeSize: 713044574208
- 4:
- n: G:\
- freeSize: 294807175168
- 0:
- monitors:
- 0:
- x: 0
- y: 0
- dX: 1920
- dY: 1080
- pPI: 96
- primary: 1
- 0:
- monitorDevices:
- screenW: 1920
- screenH: 1080
- list:
- 0:
- name: BenQ GL2460
- type:
- manufacturer: BenQ
- width: -1
- height: -1
- ppiX: 96
- ppiY: 96
- availability: Offline
- 0:
- startups:
- list:
- 0:
- name: OneDriveSetup
- command: C:\Windows\SysWOW64\OneDriveSetup.exe /thfirstsetup
- location: HKU\S-1-5-19\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: NT AUTHORITY\LOCAL SERVICE
- 1:
- name: OneDriveSetup
- command: C:\Windows\SysWOW64\OneDriveSetup.exe /thfirstsetup
- location: HKU\S-1-5-20\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: NT AUTHORITY\NETWORK SERVICE
- 2:
- name: EPSON TX820 Artisan830
- command: C:\WINDOWS\system32\spool\DRIVERS\x64\3\E_IATIGXP.EXE /FU "C:\WINDOWS\TEMP\E_S4ED3.tmp" /EF "HKCU"
- location: HKU\S-1-5-21-22906876-1841779347-426123776-1001\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: DESKTOP-BMC3PJ4\RevMi
- 3:
- name: AudialsNotifier
- command: C:\Program Files (x86)\Audials\Audials Music Recorder 2019\AudialsNotifier.exe
- location: HKU\S-1-5-21-22906876-1841779347-426123776-1001\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: DESKTOP-BMC3PJ4\RevMi
- 4:
- name: SecurityHealth
- command: %windir%\system32\SecurityHealthSystray.exe
- location: HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 5:
- name: RtkAudUService
- command: "C:\WINDOWS\System32\RtkAudUService64.exe" -background
- location: HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 6:
- name: Platinum
- command: "C:\Program Files\Trend Micro\Titanium\plugin\Pt\PtSessionAgent.exe" 1
- location: HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 7:
- name: IAStorIcon
- command: "C:\Program Files\Intel\Intel(R) Rapid Storage Technology\IAStorIconLaunch.exe" "C:\Program Files\Intel\Intel(R) Rapid Storage Technology\IAStorIcon.exe" 60
- location: HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 8:
- name: Trend Micro Client Framework
- command: "C:\Program Files\Trend Micro\UniClient\UiFrmWrk\UIWatchDog.exe"
- location: HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 9:
- name: Nero BackItUp
- command: "D:\Program Files (x86)\Nero\Nero Platinum\Nero BackItUp\BackItUp.exe" /WinStart
- location: HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 10:
- name: DriveSpan
- command: D:\Program Files (x86)\Nero\Transfer\Transfer.exe
- location: HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 11:
- name: TrayProcess
- command: "C:\Program Files (x86)\EaseUS\Todo Backup\bin\TrayProcess.exe" autorun
- location: HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 12:
- name: WDDiscovery
- command: C:\Program Files (x86)\Western Digital\Discovery\Current\WD Discovery.exe --autolaunch
- location: HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run
- user: Public
- 0:
- list:
- cpus:
- list:
- 0:
- codeName:
- descr: Intel64 Family 6 Model 158 Stepping 12
- frequency: 3696
- coresCount: 6
- 0:
- list:
- startMenu:
- list:
- 0:
- name: Default:Start Menu
- groupName: Start Menu
- user: Default
- 1:
- name: Default:Start Menu\Programs
- groupName: Start Menu\Programs
- user: Default
- 2:
- name: Default:Start Menu\Programs\Accessibility
- groupName: Start Menu\Programs\Accessibility
- user: Default
- 3:
- name: Default:Start Menu\Programs\Accessories
- groupName: Start Menu\Programs\Accessories
- user: Default
- 4:
- name: Default:Start Menu\Programs\Maintenance
- groupName: Start Menu\Programs\Maintenance
- user: Default
- 5:
- name: Default:Start Menu\Programs\System Tools
- groupName: Start Menu\Programs\System Tools
- user: Default
- 6:
- name: Default:Start Menu\Programs\Windows PowerShell
- groupName: Start Menu\Programs\Windows PowerShell
- user: Default
- 7:
- name: Public:Start Menu
- groupName: Start Menu
- user: Public
- 8:
- name: Public:Start Menu\Programs
- groupName: Start Menu\Programs
- user: Public
- 9:
- name: Public:Start Menu\Programs\ABBYY FineReader 9.0 Sprint
- groupName: Start Menu\Programs\ABBYY FineReader 9.0 Sprint
- user: Public
- 10:
- name: Public:Start Menu\Programs\Accessibility
- groupName: Start Menu\Programs\Accessibility
- user: Public
- 11:
- name: Public:Start Menu\Programs\Accessories
- groupName: Start Menu\Programs\Accessories
- user: Public
- 12:
- name: Public:Start Menu\Programs\Accessories\System Tools
- groupName: Start Menu\Programs\Accessories\System Tools
- user: Public
- 13:
- name: Public:Start Menu\Programs\Administrative Tools
- groupName: Start Menu\Programs\Administrative Tools
- user: Public
- 14:
- name: Public:Start Menu\Programs\Auslogics
- groupName: Start Menu\Programs\Auslogics
- user: Public
- 15:
- name: Public:Start Menu\Programs\Auslogics\BitReplica
- groupName: Start Menu\Programs\Auslogics\BitReplica
- user: Public
- 16:
- name: Public:Start Menu\Programs\Auslogics\BoostSpeed
- groupName: Start Menu\Programs\Auslogics\BoostSpeed
- user: Public
- 17:
- name: Public:Start Menu\Programs\AVS4YOU
- groupName: Start Menu\Programs\AVS4YOU
- user: Public
- 18:
- name: Public:Start Menu\Programs\AVS4YOU\Audio
- groupName: Start Menu\Programs\AVS4YOU\Audio
- user: Public
- 19:
- name: Public:Start Menu\Programs\AVS4YOU\Burning
- groupName: Start Menu\Programs\AVS4YOU\Burning
- user: Public
- 20:
- name: Public:Start Menu\Programs\AVS4YOU\Documents
- groupName: Start Menu\Programs\AVS4YOU\Documents
- user: Public
- 21:
- name: Public:Start Menu\Programs\AVS4YOU\Image
- groupName: Start Menu\Programs\AVS4YOU\Image
- user: Public
- 22:
- name: Public:Start Menu\Programs\AVS4YOU\System Utilities
- groupName: Start Menu\Programs\AVS4YOU\System Utilities
- user: Public
- 23:
- name: Public:Start Menu\Programs\AVS4YOU\Video
- groupName: Start Menu\Programs\AVS4YOU\Video
- user: Public
- 24:
- name: Public:Start Menu\Programs\D
- groupName: Start Menu\Programs\D
- user: Public
- 25:
- name: Public:Start Menu\Programs\D\Earth Viewpoint
- groupName: Start Menu\Programs\D\Earth Viewpoint
- user: Public
- 26:
- name: Public:Start Menu\Programs\EaseUS Partition Master 14.5
- groupName: Start Menu\Programs\EaseUS Partition Master 14.5
- user: Public
- 27:
- name: Public:Start Menu\Programs\EaseUS Todo Backup 12.5
- groupName: Start Menu\Programs\EaseUS Todo Backup 12.5
- user: Public
- 28:
- name: Public:Start Menu\Programs\EPSON
- groupName: Start Menu\Programs\EPSON
- user: Public
- 29:
- name: Public:Start Menu\Programs\EPSON\EPSON Scan
- groupName: Start Menu\Programs\EPSON\EPSON Scan
- user: Public
- 30:
- name: Public:Start Menu\Programs\EPSON\EPSON TX820 Artisan830 Series
- groupName: Start Menu\Programs\EPSON\EPSON TX820 Artisan830 Series
- user: Public
- 31:
- name: Public:Start Menu\Programs\Epson Software
- groupName: Start Menu\Programs\Epson Software
- user: Public
- 32:
- name: Public:Start Menu\Programs\Epson Software\Read Me
- groupName: Start Menu\Programs\Epson Software\Read Me
- user: Public
- 33:
- name: Public:Start Menu\Programs\GoldWave
- groupName: Start Menu\Programs\GoldWave
- user: Public
- 34:
- name: Public:Start Menu\Programs\Google Earth
- groupName: Start Menu\Programs\Google Earth
- user: Public
- 35:
- name: Public:Start Menu\Programs\Intel
- groupName: Start Menu\Programs\Intel
- user: Public
- 36:
- name: Public:Start Menu\Programs\Maintenance
- groupName: Start Menu\Programs\Maintenance
- user: Public
- 37:
- name: Public:Start Menu\Programs\Microsoft Office Tools
- groupName: Start Menu\Programs\Microsoft Office Tools
- user: Public
- 38:
- name: Public:Start Menu\Programs\Nero
- groupName: Start Menu\Programs\Nero
- user: Public
- 39:
- name: Public:Start Menu\Programs\Nero Platinum
- groupName: Start Menu\Programs\Nero Platinum
- user: Public
- 40:
- name: Public:Start Menu\Programs\REALTEK USB Wireless LAN Utility
- groupName: Start Menu\Programs\REALTEK USB Wireless LAN Utility
- user: Public
- 41:
- name: Public:Start Menu\Programs\StartUp
- groupName: Start Menu\Programs\StartUp
- user: Public
- 42:
- name: Public:Start Menu\Programs\System Tools
- groupName: Start Menu\Programs\System Tools
- user: Public
- 43:
- name: Public:Start Menu\Programs\Trend Micro Password Manager
- groupName: Start Menu\Programs\Trend Micro Password Manager
- user: Public
- 44:
- name: Public:Start Menu\Programs\Trend Micro Troubleshooting Tool
- groupName: Start Menu\Programs\Trend Micro Troubleshooting Tool
- user: Public
- 45:
- name: Public:Start Menu\Programs\WD Discovery
- groupName: Start Menu\Programs\WD Discovery
- user: Public
- 46:
- name: Public:Start Menu\Programs\Windows PowerShell
- groupName: Start Menu\Programs\Windows PowerShell
- user: Public
- 47:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu
- groupName: Start Menu
- user: DESKTOP-BMC3PJ4\RevMi
- 48:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs
- groupName: Start Menu\Programs
- user: DESKTOP-BMC3PJ4\RevMi
- 49:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Accessibility
- groupName: Start Menu\Programs\Accessibility
- user: DESKTOP-BMC3PJ4\RevMi
- 50:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Accessories
- groupName: Start Menu\Programs\Accessories
- user: DESKTOP-BMC3PJ4\RevMi
- 51:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Administrative Tools
- groupName: Start Menu\Programs\Administrative Tools
- user: DESKTOP-BMC3PJ4\RevMi
- 52:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\AVS4YOU
- groupName: Start Menu\Programs\AVS4YOU
- user: DESKTOP-BMC3PJ4\RevMi
- 53:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Maintenance
- groupName: Start Menu\Programs\Maintenance
- user: DESKTOP-BMC3PJ4\RevMi
- 54:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Startup
- groupName: Start Menu\Programs\Startup
- user: DESKTOP-BMC3PJ4\RevMi
- 55:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\System Tools
- groupName: Start Menu\Programs\System Tools
- user: DESKTOP-BMC3PJ4\RevMi
- 56:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Trend Micro Maximum Security
- groupName: Start Menu\Programs\Trend Micro Maximum Security
- user: DESKTOP-BMC3PJ4\RevMi
- 57:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Trend Micro Maximum Security\More Tools and Help
- groupName: Start Menu\Programs\Trend Micro Maximum Security\More Tools and Help
- user: DESKTOP-BMC3PJ4\RevMi
- 58:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Windows PowerShell
- groupName: Start Menu\Programs\Windows PowerShell
- user: DESKTOP-BMC3PJ4\RevMi
- 59:
- name: DESKTOP-BMC3PJ4\RevMi:Start Menu\Programs\Zoom
- groupName: Start Menu\Programs\Zoom
- user: DESKTOP-BMC3PJ4\RevMi
- 0:
- list:
- devices:
- list:
- 0:
- classID: USB
- name: Intel(R) USB 3.1 eXtensible Host Controller - 1.10 (Microsoft)
- manufacturer: Generic USB xHCI Host Controller
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 1/09/2020
- driverVersion: 10.0.19041.488
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0000
- 1:
- classID: Unknown
- name: Intel(R) Management and Security Application Local Management
- manufacturer: Intel
- classGUID: {5C4C3332-344D-483C-8739-259E934C9CC8}
- driverProvider: Intel
- driverDate: 4/05/2020
- driverVersion: 2019.14.0.1587
- driverGUID: {5c4c3332-344d-483c-8739-259e934c9cc8}\0006
- 2:
- classID: System
- name: Motherboard resources
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0044
- 3:
- classID: System
- name: Motherboard resources
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0039
- 4:
- classID: System
- name: Motherboard resources
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0048
- 5:
- classID: System
- name: Motherboard resources
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0043
- 6:
- classID: CDROM
- name: HL-DT-ST DVDRAM GH24NSD1
- manufacturer: (Standard CD-ROM drives)
- classGUID: {4D36E965-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e965-e325-11ce-bfc1-08002be10318}\0000
- 7:
- classID: Processor
- name: Intel(R) Core(TM) i5-9600K CPU @ 3.70GHz
- manufacturer: Intel
- classGUID: {50127DC3-0F36-415E-A6CC-4CB3BE910B65}
- driverProvider: Microsoft
- driverDate: 21/04/2009
- driverVersion: 10.0.19041.1
- driverGUID: {50127dc3-0f36-415e-a6cc-4cb3be910b65}\0000
- 8:
- classID: Processor
- name: Intel(R) Core(TM) i5-9600K CPU @ 3.70GHz
- manufacturer: Intel
- classGUID: {50127DC3-0F36-415E-A6CC-4CB3BE910B65}
- driverProvider: Microsoft
- driverDate: 21/04/2009
- driverVersion: 10.0.19041.1
- driverGUID: {50127dc3-0f36-415e-a6cc-4cb3be910b65}\0001
- 9:
- classID: Processor
- name: Intel(R) Core(TM) i5-9600K CPU @ 3.70GHz
- manufacturer: Intel
- classGUID: {50127DC3-0F36-415E-A6CC-4CB3BE910B65}
- driverProvider: Microsoft
- driverDate: 21/04/2009
- driverVersion: 10.0.19041.1
- driverGUID: {50127dc3-0f36-415e-a6cc-4cb3be910b65}\0002
- 10:
- classID: Processor
- name: Intel(R) Core(TM) i5-9600K CPU @ 3.70GHz
- manufacturer: Intel
- classGUID: {50127DC3-0F36-415E-A6CC-4CB3BE910B65}
- driverProvider: Microsoft
- driverDate: 21/04/2009
- driverVersion: 10.0.19041.1
- driverGUID: {50127dc3-0f36-415e-a6cc-4cb3be910b65}\0003
- 11:
- classID: Processor
- name: Intel(R) Core(TM) i5-9600K CPU @ 3.70GHz
- manufacturer: Intel
- classGUID: {50127DC3-0F36-415E-A6CC-4CB3BE910B65}
- driverProvider: Microsoft
- driverDate: 21/04/2009
- driverVersion: 10.0.19041.1
- driverGUID: {50127dc3-0f36-415e-a6cc-4cb3be910b65}\0004
- 12:
- classID: Processor
- name: Intel(R) Core(TM) i5-9600K CPU @ 3.70GHz
- manufacturer: Intel
- classGUID: {50127DC3-0F36-415E-A6CC-4CB3BE910B65}
- driverProvider: Microsoft
- driverDate: 21/04/2009
- driverVersion: 10.0.19041.1
- driverGUID: {50127dc3-0f36-415e-a6cc-4cb3be910b65}\0005
- 13:
- classID: System
- name: ACPI Fan
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0018
- 14:
- classID: System
- name: ACPI Fan
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0019
- 15:
- classID: System
- name: ACPI Fan
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0020
- 16:
- classID: System
- name: ACPI Fan
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0021
- 17:
- classID: System
- name: ACPI Fan
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0022
- 18:
- classID: USB
- name: USB Root Hub (USB 3.0)
- manufacturer: (Standard USB HUBs)
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 9/05/2020
- driverVersion: 10.0.19041.264
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0001
- 19:
- classID: System
- name: ACPI Processor Aggregator
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0009
- 20:
- classID: Unknown
- name: Root Print Queue
- manufacturer: Microsoft
- classGUID: {1ED2BBF9-11F0-4084-B21F-AD83A8E6DCDC}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {1ed2bbf9-11f0-4084-b21f-ad83a8e6dcdc}\0000
- 21:
- classID: System
- name: Volume Manager
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0054
- 22:
- classID: System
- name: PCI standard host CPU bridge
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0026
- 23:
- classID: Unknown
- name: Realtek Audio Universal Service
- manufacturer: Realtek
- classGUID: {5C4C3332-344D-483C-8739-259E934C9CC8}
- driverProvider: Realtek
- driverDate: 7/07/2020
- driverVersion: 1.0.0.274
- driverGUID: {5c4c3332-344d-483c-8739-259e934c9cc8}\0002
- 24:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0003
- 25:
- classID: MEDIA
- name: Realtek(R) Audio
- manufacturer: Realtek
- classGUID: {4D36E96C-E325-11CE-BFC1-08002BE10318}
- driverProvider: Realtek Semiconductor Corp.
- driverDate: 26/03/2020
- driverVersion: 6.0.8924.1
- driverGUID: {4d36e96c-e325-11ce-bfc1-08002be10318}\0003
- 26:
- classID: Unknown
- name: System Firmware
- manufacturer: Microsoft
- classGUID: {F2E7DD72-6468-4E36-B6F1-6488F42C1B52}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {f2e7dd72-6468-4e36-b6f1-6488f42c1b52}\0000
- 27:
- classID: Net
- name: WAN Miniport (PPPOE)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0009
- 28:
- classID: System
- name: Microsoft Basic Display Driver
- manufacturer: (Standard display types)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0055
- 29:
- classID: System
- name: ACPI Sleep Button
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0011
- 30:
- classID: WPD
- name: H:\
- manufacturer: EPSON
- classGUID: {EEC5AD98-8080-425F-922A-DABF3DE3F69A}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {eec5ad98-8080-425f-922a-dabf3de3f69a}\0002
- 31:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0006
- 32:
- classID: System
- name: Microsoft Windows Management Interface for ACPI
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0016
- 33:
- classID: Unknown
- name: WiFi
- manufacturer: Microsoft
- classGUID: {62F9C741-B25A-46CE-B54C-9BCCCE08B6F2}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {62f9c741-b25a-46ce-b54c-9bccce08b6f2}\0004
- 34:
- classID: System
- name: Intel(R) PCI Express Root Port #3 - A33A
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 18/07/1968
- driverVersion: 10.1.16.7
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0033
- 35:
- classID: System
- name: ACPI Thermal Zone
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0023
- 36:
- classID: System
- name: ACPI Thermal Zone
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0017
- 37:
- classID: Unknown
- name: Microsoft RRAS Root Enumerator
- manufacturer: Microsoft
- classGUID: {62F9C741-B25A-46CE-B54C-9BCCCE08B6F2}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {62f9c741-b25a-46ce-b54c-9bccce08b6f2}\0002
- 38:
- classID: DiskDrive
- name: WDC WD10EZEX-22MFCA0
- manufacturer: (Standard disk drives)
- classGUID: {4D36E967-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e967-e325-11ce-bfc1-08002be10318}\0000
- 39:
- classID: Unknown
- name: Microsoft Print to PDF
- manufacturer: Microsoft
- classGUID: {1ED2BBF9-11F0-4084-B21F-AD83A8E6DCDC}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {1ed2bbf9-11f0-4084-b21f-ad83a8e6dcdc}\0006
- 40:
- classID: Net
- name: WAN Miniport (PPTP)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0008
- 41:
- classID: HIDClass
- name: Microsoft Hardware USB Mouse
- manufacturer: Microsoft
- classGUID: {745A17A0-74D3-11D0-B6FE-00A0C90F57DA}
- driverProvider: Microsoft
- driverDate: 27/10/2015
- driverVersion: 9.9.108.0
- driverGUID: {745a17a0-74d3-11d0-b6fe-00a0c90f57da}\0011
- 42:
- classID: System
- name: Microsoft Hyper-V Virtualization Infrastructure Driver
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.423
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0000
- 43:
- classID: System
- name: High Precision Event Timer
- manufacturer: Intel
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Intel
- driverDate: 7/11/2008
- driverVersion: 7.0.1.1011
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0045
- 44:
- classID: Unknown
- name: Generic software component
- manufacturer: Microsoft
- classGUID: {5C4C3332-344D-483C-8739-259E934C9CC8}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {5c4c3332-344d-483c-8739-259e934c9cc8}\0003
- 45:
- classID: Net
- name: WAN Miniport (IKEv2)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0006
- 46:
- classID: System
- name: Composite Bus Enumerator
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0001
- 47:
- classID: HIDClass
- name: USB Input Device
- manufacturer: (Standard system devices)
- classGUID: {745A17A0-74D3-11D0-B6FE-00A0C90F57DA}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {745a17a0-74d3-11d0-b6fe-00a0c90f57da}\0008
- 48:
- classID: System
- name: Microsoft Virtual Drive Enumerator
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0053
- 49:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0002
- 50:
- classID: SCSIAdapter
- name: Microsoft Storage Spaces Controller
- manufacturer: Microsoft
- classGUID: {4D36E97B-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.423
- driverGUID: {4d36e97b-e325-11ce-bfc1-08002be10318}\0001
- 51:
- classID: HIDClass
- name: USB Input Device
- manufacturer: (Standard system devices)
- classGUID: {745A17A0-74D3-11D0-B6FE-00A0C90F57DA}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {745a17a0-74d3-11d0-b6fe-00a0c90f57da}\0007
- 52:
- classID: Unknown
- name: Stereo Mix (Realtek(R) Audio)
- manufacturer: Microsoft
- classGUID: {C166523C-FE0C-4A94-A586-F1A80CFBBF3E}
- driverProvider: Microsoft
- driverDate: 6/12/2019
- driverVersion: 10.0.19041.1
- driverGUID: {c166523c-fe0c-4a94-a586-f1a80cfbbf3e}\0009
- 53:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0000
- 54:
- classID: Ports
- name: Communications Port (COM1)
- manufacturer: (Standard port types)
- classGUID: {4D36E978-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e978-e325-11ce-bfc1-08002be10318}\0000
- 55:
- classID: Net
- name: Microsoft Kernel Debug Network Adapter
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0000
- 56:
- classID: VolumeSnapshot
- name: Generic volume shadow copy
- manufacturer: Microsoft
- classGUID: {533C5B84-EC70-11D2-9505-00C04F79DEAF}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {533c5b84-ec70-11d2-9505-00c04f79deaf}\0000
- 57:
- classID: VolumeSnapshot
- name: Generic volume shadow copy
- manufacturer: Microsoft
- classGUID: {533C5B84-EC70-11D2-9505-00C04F79DEAF}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {533c5b84-ec70-11d2-9505-00c04f79deaf}\0001
- 58:
- classID: VolumeSnapshot
- name: Generic volume shadow copy
- manufacturer: Microsoft
- classGUID: {533C5B84-EC70-11D2-9505-00C04F79DEAF}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {533c5b84-ec70-11d2-9505-00c04f79deaf}\0002
- 59:
- classID: USB
- name: Generic SuperSpeed USB Hub
- manufacturer: (Standard USB HUBs)
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 9/05/2020
- driverVersion: 10.0.19041.264
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0023
- 60:
- classID: System
- name: Motherboard resources
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0040
- 61:
- classID: Keyboard
- name: HID Keyboard Device
- manufacturer: (Standard keyboards)
- classGUID: {4D36E96B-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e96b-e325-11ce-bfc1-08002be10318}\0001
- 62:
- classID: System
- name: System CMOS/real time clock
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0049
- 63:
- classID: System
- name: Intel(R) Management Engine Interface
- manufacturer: Intel
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Intel
- driverDate: 24/03/2020
- driverVersion: 2013.14.0.1529
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0030
- 64:
- classID: Unknown
- name: Realtek Audio Effects Component
- manufacturer: Realtek
- classGUID: {5C4C3332-344D-483C-8739-259E934C9CC8}
- driverProvider: Realtek
- driverDate: 7/07/2020
- driverVersion: 11.0.6000.792
- driverGUID: {5c4c3332-344d-483c-8739-259e934c9cc8}\0000
- 65:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0010
- 66:
- classID: System
- name: Synaptics SMBus Driver
- manufacturer: Synaptics
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Synaptics
- driverDate: 27/04/2020
- driverVersion: 19.5.32.103
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0037
- 67:
- classID: Net
- name: Realtek Gaming GbE Family Controller
- manufacturer: Realtek
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Realtek
- driverDate: 26/05/2020
- driverVersion: 10.42.526.2020
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0001
- 68:
- classID: System
- name: Programmable interrupt controller
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0046
- 69:
- classID: System
- name: UMBus Root Bus Enumerator
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0002
- 70:
- classID: System
- name: Intel(R) Thermal Subsystem - A379
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 18/07/1968
- driverVersion: 10.1.16.7
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0028
- 71:
- classID: Unknown
- name: Intel(R) Dynamic Application Loader Host Interface
- manufacturer: Intel
- classGUID: {5C4C3332-344D-483C-8739-259E934C9CC8}
- driverProvider: Intel
- driverDate: 11/04/2019
- driverVersion: 1915.4.0.1049
- driverGUID: {5c4c3332-344d-483c-8739-259e934c9cc8}\0004
- 72:
- classID: System
- name: Microsoft Windows Management Interface for ACPI
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0012
- 73:
- classID: System
- name: Intel(R) Watchdog Timer Driver (Intel(R) WDT)
- manufacturer: Intel
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Intel
- driverDate: 19/09/2017
- driverVersion: 11.7.0.1000
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0051
- 74:
- classID: DiskDrive
- name: WDC WD5000AADS-00M2B0
- manufacturer: (Standard disk drives)
- classGUID: {4D36E967-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e967-e325-11ce-bfc1-08002be10318}\0002
- 75:
- classID: Unknown
- name: head-Phone (Realtek(R) Audio)
- manufacturer: Microsoft
- classGUID: {C166523C-FE0C-4A94-A586-F1A80CFBBF3E}
- driverProvider: Microsoft
- driverDate: 6/12/2019
- driverVersion: 10.0.19041.1
- driverGUID: {c166523c-fe0c-4a94-a586-f1a80cfbbf3e}\0027
- 76:
- classID: Unknown
- name: Microsoft Radio Device Enumeration Bus
- manufacturer: Microsoft
- classGUID: {62F9C741-B25A-46CE-B54C-9BCCCE08B6F2}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {62f9c741-b25a-46ce-b54c-9bccce08b6f2}\0003
- 77:
- classID: System
- name: Intel(R) PCI Express Root Port #9 - A330
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 18/07/1968
- driverVersion: 10.1.16.7
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0034
- 78:
- classID: Unknown
- name: BAUHN 4K Android TV
- manufacturer: MTC
- classGUID: {62F9C741-B25A-46CE-B54C-9BCCCE08B6F2}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {62f9c741-b25a-46ce-b54c-9bccce08b6f2}\0005
- 79:
- classID: Unknown
- name: Microsoft Device Association Root Enumerator
- manufacturer: Microsoft
- classGUID: {62F9C741-B25A-46CE-B54C-9BCCCE08B6F2}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {62f9c741-b25a-46ce-b54c-9bccce08b6f2}\0001
- 80:
- classID: DiskDrive
- name: WDC WD10EARS-00Y5B1
- manufacturer: (Standard disk drives)
- classGUID: {4D36E967-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e967-e325-11ce-bfc1-08002be10318}\0003
- 81:
- classID: Computer
- name: ACPI x64-based PC
- manufacturer: (Standard computers)
- classGUID: {4D36E966-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e966-e325-11ce-bfc1-08002be10318}\0000
- 82:
- classID: Net
- name: WAN Miniport (Network Monitor)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0012
- 83:
- classID: Net
- name: WAN Miniport (IP)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0010
- 84:
- classID: Unknown
- name: EPSON TX820 Artisan830
- manufacturer: EPSON
- classGUID: {1ED2BBF9-11F0-4084-B21F-AD83A8E6DCDC}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {1ed2bbf9-11f0-4084-b21f-ad83a8e6dcdc}\0001
- 85:
- classID: System
- name: Microsoft Windows Management Interface for ACPI
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0013
- 86:
- classID: System
- name: PCI Express Root Complex
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.488
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0008
- 87:
- classID: Printer
- name: EPSON TX820 Artisan830 Series
- manufacturer: EPSON
- classGUID: {4D36E979-E325-11CE-BFC1-08002BE10318}
- driverProvider: EPSON
- driverDate: 9/08/2012
- driverVersion: 6.72.0.0
- driverGUID: {4d36e979-e325-11ce-bfc1-08002be10318}\0000
- 88:
- classID: USB
- name: Generic USB Hub
- manufacturer: (Standard USB HUBs)
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 9/05/2020
- driverVersion: 10.0.19041.264
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0024
- 89:
- classID: System
- name: Intel(R) PCI Express Root Port #1 - A338
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 18/07/1968
- driverVersion: 10.1.16.7
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0032
- 90:
- classID: HIDClass
- name: HID-compliant system controller
- manufacturer: (Standard system devices)
- classGUID: {745A17A0-74D3-11D0-B6FE-00A0C90F57DA}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {745a17a0-74d3-11d0-b6fe-00a0c90f57da}\0010
- 91:
- classID: System
- name: PCI standard RAM Controller
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0029
- 92:
- classID: HIDClass
- name: HID-compliant consumer control device
- manufacturer: Microsoft
- classGUID: {745A17A0-74D3-11D0-B6FE-00A0C90F57DA}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {745a17a0-74d3-11d0-b6fe-00a0c90f57da}\0009
- 93:
- classID: System
- name: Intel(R) SPI (flash) Controller - A324
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 18/07/1968
- driverVersion: 10.1.16.7
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0038
- 94:
- classID: System
- name: ACPI Power Button
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0015
- 95:
- classID: System
- name: Microsoft ACPI-Compliant System
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.488
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0006
- 96:
- classID: System
- name: Microsoft Basic Render Driver
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.84
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0056
- 97:
- classID: Net
- name: WAN Miniport (SSTP)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0005
- 98:
- classID: Mouse
- name: HID-compliant mouse
- manufacturer: Microsoft
- classGUID: {4D36E96F-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e96f-e325-11ce-bfc1-08002be10318}\0001
- 99:
- classID: USB
- name: USB Composite Device
- manufacturer: (Standard USB Host Controller)
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.488
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0004
- 100:
- classID: System
- name: Microsoft UEFI-Compliant System
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0007
- 101:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0001
- 102:
- classID: System
- name: ACPI Fixed Feature Button
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0025
- 103:
- classID: Unknown
- name: OneNote (Desktop)
- manufacturer: Microsoft
- classGUID: {1ED2BBF9-11F0-4084-B21F-AD83A8E6DCDC}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {1ed2bbf9-11f0-4084-b21f-ad83a8e6dcdc}\0002
- 104:
- classID: System
- name: Intel(R) Xeon(R) E3 - 1200/1500 v5/6th Gen Intel(R) Core(TM) PCIe Controller (x16) - 1901
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 2/01/2018
- driverVersion: 10.1.1.45
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0027
- 105:
- classID: Monitor
- name: BenQ GL2460
- manufacturer: BenQ
- classGUID: {4D36E96E-E325-11CE-BFC1-08002BE10318}
- driverProvider: BenQ
- driverDate: 5/06/2018
- driverVersion: 1.0.0.0
- driverGUID: {4d36e96e-e325-11ce-bfc1-08002be10318}\0001
- 106:
- classID: Net
- name: Microsoft Wi-Fi Direct Virtual Adapter
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0003
- 107:
- classID: Net
- name: Microsoft Wi-Fi Direct Virtual Adapter #2
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0004
- 108:
- classID: System
- name: Intel(R) Power Engine Plug-in
- manufacturer: Intel Corporation
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.488
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0014
- 109:
- classID: System
- name: Numeric data processor
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0047
- 110:
- classID: USB
- name: Generic USB Hub
- manufacturer: (Standard USB HUBs)
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 9/05/2020
- driverVersion: 10.0.19041.264
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0025
- 111:
- classID: DiskDrive
- name: EPSON Storage USB Device
- manufacturer: (Standard disk drives)
- classGUID: {4D36E967-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e967-e325-11ce-bfc1-08002be10318}\0006
- 112:
- classID: System
- name: Motherboard resources
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0041
- 113:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0005
- 114:
- classID: Unknown
- name: Microsoft GS Wavetable Synth
- manufacturer: Microsoft
- classGUID: {62F9C741-B25A-46CE-B54C-9BCCCE08B6F2}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {62f9c741-b25a-46ce-b54c-9bccce08b6f2}\0000
- 115:
- classID: System
- name: High Definition Audio Controller
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 6/12/2019
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0036
- 116:
- classID: MEDIA
- name: NVIDIA High Definition Audio
- manufacturer: NVIDIA
- classGUID: {4D36E96C-E325-11CE-BFC1-08002BE10318}
- driverProvider: NVIDIA Corporation
- driverDate: 8/06/2020
- driverVersion: 1.3.38.34
- driverGUID: {4d36e96c-e325-11ce-bfc1-08002be10318}\0001
- 117:
- classID: System
- name: NDIS Virtual Network Adapter Enumerator
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0003
- 118:
- classID: USB
- name: USB Composite Device
- manufacturer: (Standard USB Host Controller)
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.488
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0026
- 119:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0009
- 120:
- classID: Unknown
- name: Realtek Digital Output (Realtek(R) Audio)
- manufacturer: Microsoft
- classGUID: {C166523C-FE0C-4A94-A586-F1A80CFBBF3E}
- driverProvider: Microsoft
- driverDate: 6/12/2019
- driverVersion: 10.0.19041.1
- driverGUID: {c166523c-fe0c-4a94-a586-f1a80cfbbf3e}\0029
- 121:
- classID: System
- name: Intel(R) 300 Series Chipset Family LPC Controller (Z390) - A305
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 18/07/1968
- driverVersion: 10.1.16.7
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0035
- 122:
- classID: System
- name: Intel(R) Serial IO GPIO Host Controller - INT3450
- manufacturer: Intel Corporation
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Intel Corporation
- driverDate: 22/11/2019
- driverVersion: 30.100.1947.3
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0042
- 123:
- classID: Volume
- name: Volume
- manufacturer: Microsoft
- classGUID: {71A27CDD-812A-11D0-BEC7-08002BE2092F}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {71a27cdd-812a-11d0-bec7-08002be2092f}\0004
- 124:
- classID: Display
- name: NVIDIA GeForce GT 1030
- manufacturer: NVIDIA
- classGUID: {4D36E968-E325-11CE-BFC1-08002BE10318}
- driverProvider: NVIDIA
- driverDate: 24/07/2019
- driverVersion: 26.21.14.3200
- driverGUID: {4d36e968-e325-11ce-bfc1-08002be10318}\0000
- 125:
- classID: System
- name: Intel(R) PCI Express Root Port #17 - A340
- manufacturer: INTEL
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: INTEL
- driverDate: 18/07/1968
- driverVersion: 10.1.16.7
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0031
- 126:
- classID: System
- name: Microsoft System Management BIOS Driver
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0057
- 127:
- classID: System
- name: Motherboard resources
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0024
- 128:
- classID: Unknown
- name: Intel(R) iCLS Client
- manufacturer: Intel
- classGUID: {5C4C3332-344D-483C-8739-259E934C9CC8}
- driverProvider: Intel
- driverDate: 25/09/2019
- driverVersion: 1.58.48.0
- driverGUID: {5c4c3332-344d-483c-8739-259e934c9cc8}\0005
- 129:
- classID: System
- name: Microsoft Windows Management Interface for ACPI
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0010
- 130:
- classID: USB
- name: USB Mass Storage Device
- manufacturer: Compatible USB storage device
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0008
- 131:
- classID: System
- name: High Definition Audio Controller
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 6/12/2019
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0052
- 132:
- classID: System
- name: Plug and Play Software Device Enumerator
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 6/12/2019
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0004
- 133:
- classID: System
- name: Western Digital PnP virtual bus
- manufacturer: Western Digital Technologies, Inc.
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Western Digital Technologies, Inc.
- driverDate: 23/10/2017
- driverVersion: 1.0.0.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0058
- 134:
- classID: Net
- name: Realtek 8811CU Wireless LAN 802.11ac USB NIC
- manufacturer: Realtek Semiconductor Corp.
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Realtek Semiconductor Corp.
- driverDate: 4/07/2017
- driverVersion: 1030.20.206.2017
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0002
- 135:
- classID: USB
- name: USB Printing Support
- manufacturer: Microsoft
- classGUID: {36FC9E60-C465-11CF-8056-444553540000}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {36fc9e60-c465-11cf-8056-444553540000}\0007
- 136:
- classID: SCSIAdapter
- name: Intel(R) Chipset SATA/PCIe RST Premium Controller
- manufacturer: Intel Corporation
- classGUID: {4D36E97B-E325-11CE-BFC1-08002BE10318}
- driverProvider: Intel Corporation
- driverDate: 6/07/2018
- driverVersion: 16.7.0.1009
- driverGUID: {4d36e97b-e325-11ce-bfc1-08002be10318}\0000
- 137:
- classID: Unknown
- name: Realtek Hardware Support Application
- manufacturer: Realtek
- classGUID: {5C4C3332-344D-483C-8739-259E934C9CC8}
- driverProvider: Realtek
- driverDate: 30/06/2020
- driverVersion: 11.0.6000.223
- driverGUID: {5c4c3332-344d-483c-8739-259e934c9cc8}\0001
- 138:
- classID: System
- name: System timer
- manufacturer: (Standard system devices)
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0050
- 139:
- classID: System
- name: Remote Desktop Device Redirector Bus
- manufacturer: Microsoft
- classGUID: {4D36E97D-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e97d-e325-11ce-bfc1-08002be10318}\0005
- 140:
- classID: Image
- name: EPSON Artisan835/PX820/TX820
- manufacturer: EPSON
- classGUID: {6BDD1FC6-810F-11D0-BEC7-08002BE2092F}
- driverProvider: EPSON
- driverDate: 4/09/2015
- driverVersion: 3.7.7.2
- driverGUID: {6bdd1fc6-810f-11d0-bec7-08002be2092f}\0000
- 141:
- classID: DiskDrive
- name: WDC WD5000AADS-00S9B0
- manufacturer: (Standard disk drives)
- classGUID: {4D36E967-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e967-e325-11ce-bfc1-08002be10318}\0001
- 142:
- classID: Net
- name: WAN Miniport (IPv6)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0011
- 143:
- classID: Net
- name: WAN Miniport (L2TP)
- manufacturer: Microsoft
- classGUID: {4D36E972-E325-11CE-BFC1-08002BE10318}
- driverProvider: Microsoft
- driverDate: 21/06/2006
- driverVersion: 10.0.19041.1
- driverGUID: {4d36e972-e325-11ce-bfc1-08002be10318}\0007
- 0:
- list:
Dear Michael,
Thank you for posting your question on our forum.
Before sorting data, we highly recommend you to read the following articles:
1. https://support.microsoft.com/en-us/office/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
2. https://support.microsoft.com/en-us/office/sort-data-in-a-table-77b781bf-5074-41b0-897a-dc37d4515f27
To analyze formulas, you need to provide us with the information regarding the following:
- ALL the data that is involved into the formula;
- In which particular format each variable is substituted for the formula;
- In what form the answer of the formula should be;
- All the formulas in their mathematical form. Additionally, you also need to describe the meaning of each variable within these formulas;
Unfortunately, it is impossible to answer the question concerning whether it is even possible or not without the above mentioned data.
If you need any further assistance or have any other questions, please do not hesitate to contact us.
Dear Michael,
Thank you for posting your question on our forum.
Before sorting data, we highly recommend you to read the following articles:
1. https://support.microsoft.com/en-us/office/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
2. https://support.microsoft.com/en-us/office/sort-data-in-a-table-77b781bf-5074-41b0-897a-dc37d4515f27
To analyze formulas, you need to provide us with the information regarding the following:
- ALL the data that is involved into the formula;
- In which particular format each variable is substituted for the formula;
- In what form the answer of the formula should be;
- All the formulas in their mathematical form. Additionally, you also need to describe the meaning of each variable within these formulas;
Unfortunately, it is impossible to answer the question concerning whether it is even possible or not without the above mentioned data.
If you need any further assistance or have any other questions, please do not hesitate to contact us.