Hello,
I'm having a heck of a time trying figure out how to extract the data I'm needing. I'm rather new to VBA and trying to read / watch many scraping videos and I'm not getting the output I'm looking for.
Ultimately I would like to have a table pulled from a completed /sold search from...
Hello,
I have my first sheet 'Switchboard' that has this formula in Cell E1:
=WEEKNUM(TODAY(),2)
This yields '28' for the 28th week of the year.
My worksheets are labeled Week 1, Week 2, etc.
Since this is the 28th week of the year is there a way to jump to that worksheet (Week 28) ...
=Countifs(E3:E13, "M", I3:M13, "/")
I know the problem is coming from
I3:M13
Yet I don't know how to resolve it.
I want to count all "/" from range "I3:M13" that are labeled "M" in column E.
Hello,
I have an excel file with hundreds of sheets, I need something that helps me simplify the print process of selecting each sheet that i need. All the sheets that I need to print are between sheet 10 and sheet 70, sheets are labeled e.i. sheet 10 reads USA, sheet 11 is Canada...sheet 70...
I have 2 work sheets "Main" and "CheckList".
The "Main" work sheet has selections in cells B14:B29 and in cells E14:E21 (by selections i mean i have made is so that when these cells are activated they auto fill with an X)
I also have a button on the page labeled "Print"
The "CheckList" page...
Hello everyone,
As I add levels using the text pane to my labeled hierarchy chart the shapes do not move or resize to remain in the labeled level.
How do I keep them in the correct levels?
I have a packing table that I can have as many as 8 different materials used in packing a box. I have a table with the item listed and the charge associated with it. I have a column labeled as total material cost. How do I have the 8 different columns go look up the item and the cost...
Hi,
Row A has 1-16. Row B1 is labeled Full/Half. Row C1 is labeled Done. Row D1 is labeled total.
If in cell row b2 is typed full, it calculates 1 in total. If half is typed, it would calculate .5 to the total. If it could also only calculate if you type yes in cell c2-c16.
Hope this makes...
All,
I've tried to find someone post a similar question or find a similar use case to find the answer, but I'm not sure I have the right verbage to find my answer.
I'm looking for some help with the data below. I have multiple locations going down which I've labeled "red" and "blue" in this...
Hello,
I am looking for a way to sort and delete duplicates.
example below
<tbody>
number
sorted and delete duplicates
1
1
2
2
3
3
1
4
2
4
4
4
2
</tbody>
The column labeled number needs to be left the same.
Thanks for any help!
Windows 10, Excel 2010;
I have a table where the column headers match the row labels. i.e. columns beginning at B1, C1, D1 are labeled MPH001, MPH040, MPH051 etc. for 100 columns (with no pattern to the labels). The rows are labeled the same, i.e. rows A2, A3, A4 are labeled MPH001, MPH040...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.