I have a data set that looks like this:
A B C D E F
P 2 0 2 0 0 3
Q 0 3 1 1 1 0
R 6 0 0 0 1 0
S 0 5 0 3 0 0
T 0 0 5 0 0 2
U 0 0 7 0 0 0
I need to be able to search that table by putting selecting an input value from P-Q then if that selected row has a value greater than 0.
I need it to...
Sheet 1: is set up as follows with ACCOUNT is cell A1.. I have other accounts following 610200 going down from A2 to A59 with the description and amounts as seen below in other cells.
<colgroup><col width="106" style="width:80pt"> <col width="189" style="width:142pt"> <col width="80"...
Hey guys, i usually work with a lot of data both in quantity and file size. Yet sometimes i have to make a LOT of calculations in order to get result. Like, one time i had a Pivot from PowerPivot data that had around 1 million calculations. So i was wondering if you knew software, similar to...
Hi everyone, I've been struggling with this one for some time and I thought I'd throw it out there to see if anyone has experience of solving this type of problem? Sorry if its already been covered, I have looked and can't find anything quite like it.
The problem I have is I have large...
Hi,
I have a large database resembling the image below, with instances of similar text values in one column and a corresponding numerical column next to it. I am trying to modify the numerical column such that when I edit one numerical cell, all cells in the same column with similar (not...
Hi guys Could someone help me,
I use this the variable: FindCol_RowID="sv" (that is the search string the script looking for in a sheet)
then in the msgbox I get the ID of the cell
but could someone help me to
paste the cell + column into a new sheet on the same place?
See code below...
hello, i want to write a logical function assuming in C2, for lets say if another cell in column A (i have about five thousands rows) is same as A2 and the cell in B column belonging to same row as that one is not blank, then c2 shows "full" otherwise "blank"
would very much appreciate any...
I am try to format a report so it is simpler to read. Right now I export information from Access. The product names are repetitive and I want to use them as titles, so I want to keep the first title then delete all the similar ones underneath it. Right now my data looks similar to this when...
Hi there!
I have a list of data, many with a similar data code. As a result, I'd like to group the datas with the similar data code. Here's an example:
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;}...
Hi All,
I am a beginner in Macro coding. And I would like to know how the following can be done using macro.Could someone help me with this ?
<TABLE style="WIDTH: 632pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=843 border=0><COLGROUP><COL style="WIDTH: 62pt...
I have a column of names in one workbook, and a column in another workbook. Some of the names in the first workbook are misspelled. For example:
Jesse (workbook1) vs. Jessie (workbook2)
Madelynne (workbook1) vs. Madeline (workbook2)
I am trying to use a function that can look at the names in...
Hi All!
I am currently having trouble using a VLOOKUP function. The reason I have a problem is my Lookup values are slightly different to how they appear in the lookup table, but they are similar. They are in fact serial numbers, but the two data export files I am using (annoyingly!) display...
I have tried looking for similar questions in the forum and couldn't find them. If you know of any, please let me know. My problem is that in one column I have peoples names that are repeated. I need to average numbers that are in the same row as their name. So for example:
<TABLE...
This is my second posting. You guys helped me out of a REALLY tight jam last time and I appreciate it like you'll never know.
I have another question. I have a list of repairs that my company has done (32000 + items). There are several part #'s entered by several different people. Each person...
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.