how to write CONCATENATE function to connect 3 fields (AM, AN, AO).
For i = 5 To x_ws1_rows
ws1.Range("AK" & i).Value = ws1.Range("AG" & i).Value
day1 = Day(ws1.Range("AK" & i).Value)
ws1.Range("AM" & i).Value = day1
How do I make a multiple conditional formula have the ability to active/deactivate a certain condition dynamically.
The example below should clarify; I have the following formula:
This formula sums the...
I work for a church food bank that calls groups of people. they need a better way to display and track what random group numbers are called and how many families are served every day. im trying to make this easier because they are manuall entering this into notepad on an overhead projector and...
I am looking for a VB script to concatenate 3 columns as below:
A B C
abhimanyu Nagpal ECE
The output i want in A1 would be a single string with comma in the end of value from column C. Cell B1 and C1 values get deleted.
Must be 2007 compatible.
I have a table with more than 50 columns and over 3,000 rows. I need users to update multiple columns of data with valid values. Each cells needs to offer different dropdowns based on their values.
Let me try to explain:
USA_Prefix (all of the...