excel question

Hello, Hoping someone can assist me with this excel question. I would like to create List3 as it looks. If the color in List2 is in List1, then I want it to show up in List3. The part I am stuck on is getting List3 to pull green to the first row,, blue to the second row, and so on. Appreciate...

I'm looking for help to create VBA which would clear the last cell in the row when colour changes as per picture. I am not sure as well about the colour coding. I need that the last full cell after it's over 52 would be deleted maybe someone had to do this before?

Hello! I am very new to this forum and I couldn't get the XL2BB extension to work so excuse the formatting since I just copied and pasted the data from my excel file. I have data that is recorded every hour every day from 1999-11-01 to 2023. I only pasted a small portion of the cells as it has...

Hi everyone, This is my first question for this forum. Thanks a lot in advance for your help. As I showed you in the image, I have to find the 2 numbers right of H. I have tried some formulas but I could not. Like this: ==FIND(Workings_1!C2,MID(Workings_1!C2,3,2)) How can I solve this?

How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link) # i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me

How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..

I was try refresh but not show data in pivot table, how to update data ...???

How to marge 3 table into one table , because i face reference error , i tried......, pleased solving this query.... step by step.

How Hide Row According value is Zero on Pivot tables ??? Condition is zero value to hide table Entry in pivot tables.

# How to sum with unique Invoice Number wise ????? - Pleased Solve this query for formula ......very usefully trick for sale bill fill. like single invoice & two or more products in this sheet... problem is how to sum product based on unique Invoice No. - Pleased Help !!!

like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????

Columns- count a consecutive series of positive or negative numbers and then get a sum of the max frequency Example: <tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;"> A B C D E F G H I...

Hello I need help and not able to find my solution. I have in a sheet called TOC on cell J33, which updates every 2 minutes based on a = function to another sheet that uses a api query. My goal is to track last value (history) before it updates, and have the data output on another sheet...

Hi there, I'm creating a new leave planner for my team and I have followed one template and created half of the it and now struck up use the dashboard formula which can update the data by referring the data sources. I would need help on using the below formula...

Can anyone please help me figure out a formula to calculate YTD?? What I am trying to achieve: Sum all months <= current month, ONLY IF months fall within the same year CY (Calendar Year) as the current month As you can see on the screenshot below, Cell B5 indicates the current month. The...

<colgroup><col><col></colgroup><tbody> Array 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 I </tbody> <colgroup><col><col></colgroup><tbody> Lookup Value Apply Vlookup only Daiwik1 Daiwik1 value should be "A" and like wise...

I have two reports with 10 and 10 columns each. I need to copy data from "A,C,E and F" and "A,C,D, and F" columns respectively from Sheet 1 and Sheet 2 to be entered to another report to find out mismatch. How should I do this?

I am creating a dashboard and I want it to automatically create a 7-day trailing average based off the the =today() cell that it looks up on. So I have the raw data in a sheet that has the data by day: <tbody> 8/1/2015 8/2/2015 8/3/2015 8/4/2015 8/5/2015 8/6/2015 8/7/2015 8/8/2015 People...

Hi, I need a little help and I hope I can explain this correctly. I have a document with multiple sheets. (sheet1, sheet2, sheet3). There are hundreds of thousands of business names in one column on the first sheet. we will say (sheet1!A) I need to compare the name of the business to the...

Hello everyone I'm sort of new to excel VBA and new to this forum, and I was wondering if someone could help. I recently copied and pasted a macro, specifically the one in this link VBA Express : Excel - Disable Cut, Copy, Paste. It disabled copy, cut, and paste on the particular workbook, but...