I am trying to run an excel vba form to search through the lines, but for some unknown reason I get...
I have a date cell 25/10/2002 in date format with the text format (if i change the format to text)...
I'm looking for some help as I'm not really sure of the correct terms to use on my query below, so...
I have a table with list of names on each rows and 20 columns with values but some are...
Below is what I am trying to accomplish in excel. I need to find the correct code to fill the...
I need to get the top 6 repeating numbers in columns A-F , in any order would be fine , tried using...
Is it possible to count/summarize a value in a filtered excel table and subdivide that count based...
I have a column with groups of values 1, 2, 3, etc... and adjacent columns with additional details....
I'm working on a macro right now and it's producing weird results. The part that is specifically...
I am trying to concatenate values from two columns and when I use =CONCAT(A2,",",B2) it will...
This question already has an answer here: VLOOKUP with IF conditions...
I would like to calculate the per year depreciation value of items based on start date and end date...
I am trying to combine a vlookup formula with an If condition. To be more exact, I have a worksheet...
I'm trying to make a LibreOffice spreadsheet formula that populates a column based on another input...
A B C D E F ... ------------------------------------------- 1| QUARTER...
I've seen worksheets using COUNTIFS() function even when they've only specified a single criteria....
I am doing data clean up. I collected data from multiple excel spreadsheets. I am trying to achieve...
It may be a repeated question, but I couldn't find an effective solution anywhere. One of my...
So what's happening. I have a planned lot number and production lot number In K5 I have the...
So in my job, I am trying to find the average calendar days between two dates and average business...
I have an interesting puzzle. What I am trying to assign a 1 or a 2 based on the several...
I am building a model that compares scenario 'A' with scenario 'B' by setting the NPV of 'B' equal...
I have an excel model that copies data from one sheet and pastes it onto another. Some of the...
I'm using NPOI to programatically create an Excel file. One of the requirements is that it needs to...
I have an excel having data for entire year.I want to find low and high in every month using some...
I am trying to use VBA to access data off the web from excel. When I try to go to the website it is...
guys, I want to select an element from a column based on column name. This column changes its...
I am trying to run a loop with vlookup, if an IF condition is met. I have written the code provided...
I have a code that looks like this: Dim x As Double Dim ws As Worksheet Set ws =...
i have this routine: Sub toevoegen() With Worksheets(SheetSchaduwblad) aantalrijen =...