misc

Hello all, I am working on a project and I have come to a problem I don't know how to solve, I have a grid of Data, Row Descriptions (Column B), and then My headers in columns "H:AP" and then the corresponding rows in between Range("H9:AP128"). So, I need code or even a formula that will go...

I need a total SUM of each Category in Column C based off of corresponding amounts in Column D. I also need the SUMS for each Category automatically updated to a separate table. <colgroup><col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1568;"> <col width="115"...

Hi, i have a table that is 26 column's long. This table is then replicated 52 times to form a year. I input data into rows 7 - 14 (1 week plus a misc column). Is there any way I can copy just the data for the whole 52 weeks? Thanks

Sheet one contains data with range titled "Expenses" <colgroup><col width="64" style="width: 48pt;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3726;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4295;"> <col width="89"...

Hello! I've painted myself into a corner here with an IF/AND/OR statement. This is a generalization of what I'm trying to accomplish in Excel 2016. The column VEHICLE doesn't always contain the word "TRUCK" so it needs to be scrutinized. The following string causes Excel to tell me there is...

need to know how to set my chart series to pull data from every other 6 cells from the same column. i have 6 series (heb, haz, dal, etc). i have a stacked bar graph (couldn't figure out how to upload a pic of it) and currently have to manually change each series value each week to update the...

Hello! I am trying to create a formula to search the value in a static cell, searching a column in another sheet for a match and returning the value in the adjacent cell to the match on the same sheet. The matches will have duplicates, which I want to remove so that I end up with a list of...

i have two different workbooks and would like to copy & past from one to the other if certain data in one worksheet matches the other. If data in column A wb1 matches data in column A wb2 on wb1 column D will return the value of wb2 column D workbook 1...

<colgroup><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody> Sl Site_Name Value Reason 1 A 200 Act Formula in the below 2 B 250 Pas 3 A 300 MISC Site_Name Max_Value Max_VALUE_Reason 4 A 890 Act A 999 Act 5 C 700 MISC B 6 B 450 Other...

my pivot table below has filters on column a and b but I need to filter by c and d. I can't figure out how to add the filter at the top of the column like a & b and the filter icon is greyed out. <colgroup><col><col><col><col></colgroup><tbody> A B C D EE# LS2 Values 10 1 BONUS...

hi there - am working on Sales table with COGS data within as below here; am trying to get Brand name with High sales value for INV & where Sales value is "zero" & Purchase is "greater" than "Zero" i.e. line 3 should show "Brand" as "ABC" instead of "Misc - HW" <tbody> Type Date Num Item...