Array Evaluating multi-dimensional static VBA formula

[mel2017]

Hello,

I'm new to authoring formula's in excel. For work, I've been working on a 620 row formula by 11 columns which contains data from three reports with no connecting data descriptors.

Upon analysis, certain identified commonalities such as "C+, C3, 824, 444, Best, Super", need to be searched for and found to create a data key connecting the three reports.

Upon finding, I need this data to be highlighted and grouped (while remaining within the data table (report) of origin). Once grouped, this data will be combined as a master data blue print key.

The data tables will later be imported to ms access for further analysis.

Attached, are examples of array, if and match highlighting formula's which have not worked. I've also attempted conditional formatting which did not populate the needed results.

I've most recently stumbled upon the Evaluating multi-dimensional static VBA formula tutorials. However, none of the tutorials I've found for any strategy deployed, encompass the vast body of data, I need to sort, format and regroup.

Any idea's regarding the appropriate formula combination to use and or any tutorial's I may view regarding their construction would be most appreciated !!!!

 

[NARAYANK991]

Hi ,

Can you upload your Excel workbook ?

The formulae you have posted don't seem to be Excel formulae ; I might be wrong.

Narayan

 

[mel2017]

Hi ,

Can you upload your Excel workbook ?

The formulae you have posted don't seem to be Excel formulae ; I might be wrong.

Narayan

Unfortunately, I work in the insurance industry and HIPPA regulations bar the sharing of such data. However, I can state that the above array string, I am searching for:
=array(Pos=(423,127,333,222,BEST,SELECT)for($C3,$611)=HighlightColorindex wdOrange vb))
are all commonalities which are repeated throughout the 620 rows by 11 columns of which I'm attempting to return results.

The ($C3,$611) is the static array. I'm telling excel to search from Column C row3 through column K row 611 for the values: 423,127,333,222,BEST,SELECT and if in the instance of true to highlight fields containing those data variables in orange.

This is a compilation of several tutorials, where I'm trying to create one massive formula to command my worksheet. This may be more programming than a formula. I'm just learning my "primer alphabet" of this world. Please forgive me if all of my terminology for the task, I'm attempting to accomplish is not accurate.

 

[NARAYANK991]

Hi ,

Then I am afraid there is nothing more that I can do to help.

Hopefully someone else may pitch in.

The constructs you post are not Excel worksheet formulae , as far as I know.

I do not know from where you have learnt them ; possibly if you can post some links I can refer to them to get a better idea of what you are talking about.

Narayan