multi

Hi, I have a table that updates as data is entered into another sheet. I want to find the mode of this data, but exclude the zeros, since there is a lot of zeros, because data has not been entered into the original sheet yet. Here is the formula currently being used...

Hello , I have multi text files in one folder for example log001.txt log002.txt log003.txt I want to copy the content of these file in one work sheet so first file content in A and second file content in B and third file content in C etc..

Hi The following COUNTIF formula =COUNTIF(Range,"Key*")+COUNTIF(Range,"Potentially*") works perfectly well. However I want to add a further criteria which allows me to enter a start date in CELL F4 and an end date in CELL H4. I have tried adding the following formula...

Dears, kindly I want to fill Column sub Category 1 & 2 from another sheet with the Following Condition Sub Category 1 will be : if (Activity coloumn = 211 or 212) : COGS if (Activity coloumn= 111 or 231) : G&A if (Activity coloumn= 111 or 231 & Cost center = 312 & 341 ) : S&M i think i need...

Hello vba experts, Need your help in creating a report for my workbook that has two levels of data in each sht. top data on each sht applies to each row of the bottom data (errors found for tracking and report generation) in this sht and has to be carried over to a summary sheet once ready with...

Hi everyone, I've got a bit of a problem I do an index match of my sku's to tell me my stock levels from my weekly CSV readout. I put the data into sheet "CSV" the simply have a formula in sheet "Stock Level" that index matches the Sku in "D6" (for example) with the data in sheet "CSV" CSV...

Hi Folks, I have been trying to use pivot table consolidation from multiple sources but didnt manage to get the desired outcome. Im happy with any hint of solution, vba or formula / wizards... I have 3 sheets in excel where you can find similar type of data at the same locations. This is...

Hey there everyone I have a spreadsheet with data in Range B10:P97. I am attempting to create a single array of the two ranges B10:B97 and O10:O97. I have read this previous thread heavily http://www.mrexcel.com/forum/excel-questions/564473-transfer-multiple-ranges-one-array-2.html but...

Ok, well first off, I am very new to Excel/Access. Have used other scripts/DB's in the past ... granted a while ago. So please know that first when replying as I need responses in kindergarten form. I think this would go here, but since it's really an SQL question it might need to go in...

<colgroup><col></colgroup><tbody> I didn't find any formula to return most common text from 1st to 101th or even more places. ALWAYS DATA IN VERTICAL COLUMN SIMPLY AS POSSIBLE <tbody> <colgroup><col></colgroup><tbody> Naturaleza asociada ÁRBOLES FRONDOSOS JARDINES SOMBRA FRESCO...

I currently have this equation =COUNTIF($EZ29:$GD42,"TTMU")+COUNTIF($EZ29:$GD42,"TTMC")+COUNTIF($EZ29:$GD42,"TTMI") Which works fine. Was wondering if there was an easier way of doing this as typing it in is slow going when this is used month by month over a specific range. Would a LOOKUP do...

Hi all, Again I am in need of the communities vast experience and knowledge. I am trying to create a multi user secure log sheet. The whole goal is to create a logging system for call logging at work. Currently what I have is that everyone uses there own workbook and fills out everything and...

Hi, I'm an absolute VBA novice and am stuck with some code that I've been give to output multi listbox selections into a single cell. I've searched for an age to find an explanation I can understand but failed miserably - please help me retain my sanity :banghead: Everything works well until...

Hello everyone, I have been working on a userform. Part of the form included about 150 txtboxes. While searching for some coding answers to setfocus and format etc., I came across a post from Norie asking the OP of the thread I was reading why they didn't just use a listbox. :) Well, I...

Hi there, I am seeking a solution to my problem as per below: I have a sales rep spreadsheet of products sold, quantities, rep name etc & I am seeking a formula to search column A3:A400 [Date Column] for a period of time (I.e. 13 Feb - 19 Feb 2012), search column B3:B400 [State Column] for the...

Hey guys, I have to write a bit of code for a small database where I'm using Excel/VBA. I have the following database of roses that are for sale within a small company: I have a userform running that looks like this: I need a piece of code, where when the user selects the type of ROSE -...

=IF($E3=$T$3,IF($F3=$U$3,$V$2:$V$8,IF($F3=$U$4,$V$9:$V$15,IF($F3=$U$5,$V$16:$V$22,IF($F3=$U$6,$V$23:$V$29,IF($E3<>$T$4,"",IF($F3=$U$3,$V$58:$V$64,IF($F3=$U$4,$V$65:$V$71,IF($F3=$U$5,$V$72:$V$78,IF($F3=$U$5,$V$79:$V$85,"")))))))))) The bold one isn't working. I understand why but can't figure...

Hello, Formula: =IF(LOOKUP("$",G10,F10),F10*$K$3,IF(LOOKUP("€",G10,F10),F10*$K$4,IF(LOOKUP("₪",G10,F10),F10,""))) Issue :(: Only the first "IF" is working properly while the rest result in N/A# Formula goal: Currency check and exchange Further details: CELL G ($,€,₪) = CURRENCY TYPE...

I want to be able to make multiple selections from a list and have them populate in the same cell. In my file I have a worksheet with all the lists on it named "Dropdowninfo" There was a similar post here...

Hi, I have an issue, that may have been discussed on this board before, but I haven't been able to locate any discussions on. Essentially I have the following data set 2007 2008 XX YY XX YY cat 1 74 3,681 79 3,806 cat 2 565 2,835 597 2,886 cat 3 987 98,658 1,044...